Author: admin

  • Blog
  • Author: admin

Stored Procedure-Importing CSV Files into Table -SQL Server

Here is the Stored Procedure code for importing comma seperated CSV files to table. CREATE PROCEDURE [dbo].[sp_ImportScript]@filepath varchar(2000)ASBEGIN TRYdeclare @tmpsql varchar(3000)set @tmpsql=’BULK INSERT table’set @tmpsql=@tmpsql + ‘ FROM ”’ + @filepath + ””set @tmpsql=@tmpsql + ‘ WITH (FIRSTROW=2,FIELDTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘,ROWTERMINATOR =’set @tmpsql=@tmpsql + ”’,”’set @tmpsql=@tmpsql + ‘)’EXEC(@tmpsql)select @@rowcountEND TRYBEGIN CATCHDECLARE

Read More

Window Live Mail Lanuch full version

Few days back Microsoft has announced it’s new next generation free mail services windows live mail. Microsoft has announces full version of it. Microsoft also giving beta tester logo for those who have used the Microsoft live beta version of mailing services.

Read More

Lazy in C# 4.0

Before C# 4.0 there was no on demand initialization by default. So at the time of declaration we need to create a value or object will be null or we have to create on demand initialization via coding.. But with C# 4.0 we now have lazy class. As per MSDN it support lazy initialization so

Read More

Ajax Realted Keyworkd for Search Engine Optimization

Following are the some Ajax related keywords for search engine optimization.AJAX Development India,Ajax Programming, Ajax Programming India, Ajax ASP.NET Development, Ajax ASP.NET Atlas Developement, Ajax, Ajax development, Ajax application development, Ajax javascript, Ajax programming, Ajax XML, Ajax java script, Ajax java script and XML, Ajax java, Ajax network, Ajax net, Ajax php, java Ajax, Ajax

Read More
Apple Store

Copyright @2024 Dotnetjalps