Occasional error in sqlsrc.cpp when switching in a partition for a partitioned table

Hi, How to insert more rows to single table at once by using a DDL command.

You don’t use DDL to insert rows  into a table, you use DML to insert  the rows.  The BOL has a number of examples on the following link including Inserting Multiple Rows of Data:http://msdn.microsoft.com/en-us/library/dd776381.aspx

In addition to the information Jonathan provided, take a look at the Books Online topic for Table Value Contructor (http://msdn.microsoft.com/en-us/library/dd776382.aspx)  for the syntax you need as well as additional examples.Gail