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, 2046🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...