Collections:
"SELECT ... INTO" - Creating New Tables With Queries in SQL Server
How to create new tables with "SELECT ... INTO" statements in SQL Server?
✍: FYIcenter.com
Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "SELECT ... INTO" statement. The tutorial script below gives you a good example:
INSERT INTO tip VALUES (1, 'Learn SQL', 'Visit dev.fyicenter.com','2006-07-01') GO SELECT * INTO tipBackup FROM tip GO (1 rows affected) SELECT * FROM tipBackup GO id subject description create_date 1 Learn SQL Visit dev.fyicenter.com 2006-07-01 sp_columns tipBackup GO TABLE_OWNER TABLE_NAME COLUMN_TABLE TYPE_NAME ... dbo tipBackup id int ... dbo tipBackup subject varchar ... dbo tipBackup description varchar ... dbo tipBackup create_date datetime ...
As you can see, the "SELECT ... INTO" statement created a table called "tipBackup" using the same column definitions as the "tip" table and copied all data rows into "tipBackup".
⇒ "ALTER TABLE ... ADD" - Adding New Columns to Existing Tables in SQL Server
⇐ Generating CREATE TABLE Script on Existing Tables in SQL Server
2016-11-17, 2646🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...