General information
Forum:
Microsoft SQL Server
Title:
Optimizing a SQL Insert statement
I was wondering if anyone had any tips on Optimizing SQL Insert statements.
I wrote a conversion from an older legacy database system and the conversion seems real slow. I narrowed the delay down to the SQL Insert commands. Does anyone have any tips that could speed up this process ?
Insert into persons (per_name,per_address,per_city,per_state,per_zip) values
'John Smith','123 any street','any city','NY','11876')
Thanks !
Stephen J. Hunt
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only