The INSERT statement adds one or more new rows to a table. Use a SELECT subquery to specify the data values for one or more rows.
Syntax :
INSERT INTO [existing table] ([column])
SELECT [column name]
FROM [table name]
Example :
INSERT INTO dbo.Shop (ShopNo,ProductNo,Stock)
SELECT ForeignKey, Description
FROM dbo.NewShop
Subscribe to:
Post Comments (Atom)
1 comment:
Hi. my name is thanapat from thailand.
I would like to introduce my site
It's about Business Inteligence.(Microsoft Sql Server)
:)
Thank you.
www.mssqlbase.blogspot.com
Post a Comment