Difference between Select Into and Insert Into from old table?
01:35 17 May 2012

What is difference between these in terms of constraints *keys* etc.

Select Into Statement

SELECT column1, column2, someInt, someVarChar 
INTO ItemBack1 
FROM table2
WHERE table2.ID = 7

Insert Into Statement

INSERT INTO table1 ( column1, column2, someInt, someVarChar )
SELECT  table2.column1, table2.column2,
FROM    table2
WHERE   table2.ID = 7

and also

Create table ramm as select * from rammayan

Edit 1:

Database SQL Server 2008

sql sql-server-2008