...

Thanks mimran18. Thats a good point...

One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. The answer is "It depends". If all the resultsets return same number of columns then it is possib...

...

Assume that you have two identical tables in different servers. The table in production server has 100 million rows and the table in test server is empty and you want to transfer data from production server into test server to do some analysis based on ...

...

BCP is one of the fastest methods to export data to various formats like csv,txt,etc and doing this in a command mode is faster than doing it via SSMS. Let us create this simple tablecreate table test(iud int, name varchar(50)) insert into test(id,name...

Thanks Bala Krishna...

...

Import dataChoose Data source as Flat file source, browse the file, Under the Data source tab, choose the columns and make sure that Row delimiter is {CR}{LF} and column delimiter as Vertical Bar {|}, click next and choose the d...