I work with SQL Server 2008. So I need to do insert from one table to another that is not existing yet. Besides I need in one new field for table in what I insert records. How can I do it? The task is:
Copy all records from Production.Products table into new table tempdb.dbo.Products, tempdb.dbo.Products should contain 1 additional column: row_id INT NULL.
View Complete Post