Pages

Subscribe:

Ads 468x60px

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.
INSERT INTO @MyTable
SELECT OrderID, CustomerID
FROM Northwind.dbo.Orders
WHERE OrderID BETWEEN 10240 AND 10250

No comments:

Post a Comment