I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server ... bcp to copy data into a table, when I ...

I needed to copy the SQL Server ... Another potential disadvantage is that IDENTITY columns are not reset to their original Seed value with the DELETE FROM statement. A TRUNCATE statement is preferred ...

Replace "new_table" with the name of the table to create ... Microsoft's SQL Server, check the manual to see if it supports SELECT INTO. It might support the syntax or it might use another ...