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, 2281🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...