SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to create an insert statement for a table with many columns?

 

Right click on table in Object Browser of Query Analyzer. Choose script out, insert option.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page