Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Bulk Insert proc to try out ur optimization skills

By Additional Articles,

This SP can be used for bulk inserting data from an ascii text file onto a table. You have to change the structure, of the temporary table (ITEM_MASTER_TEMP) and the actual table onto which data is inserted, to suit ur needs . I wish you people workout this SP and try to optimize it as much as possible. I hope you will inform me if you find a way to optimize the proc.

Note:
In the actual proc the whole script is a single string, there is no cancatenation.

Total article views: 189 | Views in the last 30 days: 1
 
Tags
miscellaneous    
t-sql    
 
Contribute