INSERT INTO @MyTable SELECT OrderID, CustomerID FROM Northwind.dbo.Orders WHERE OrderID BETWEEN 10240 AND 10250
Monday, March 12, 2012
how to insert data with Select statement in sql server
in this sql database we will learn that how we can use a select statement to insert data in a database table using sql server.
Labels:
Database
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment