Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
performance
Hi ronnetp: thank you. Can you tell me the commands for bcp or bulk insert. I only know bcp and bulk insert are for transferring data between data file and sql server, I don't know how to do between tables. thanks- gzm219
- Post #3
- Forum: Microsoft SQL Server: Programming
-
EXEC master..xp_cmdshell - error not recognized as an
Hi snoopyyu: thank you. Can you tell me the commands for bcp or bulk insert. I only know bcp and bulk insert are for transferring data between data file and sql server, I don't know how to do between tables. thanks- gzm219
- Post #4
- Forum: Microsoft SQL Server: Programming
-
performance
In a sql70 stored procedure, I use command: insert into <target_table> select * from <source_table> to isnert records to target table but the target table is to very big and has many indexes, the operation is very slow. I recompile several times but still slow. How to improve? please help...- gzm219
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
