SQL: How to SELECT * INTO [temp table] FROM [stored procedure]

Question

How to convert c # inline queries into stored procedure written in transact sql?

Answer 1

Lets have one example for same:

Let's suppose you want a stored procedure to return a list of all the people with a given last name. The code for the stored procedure might look like this:

CREATE PROCEDURE dbo.GetPeopleByLastName (@LastName NVARCHAR(50))
AS
SELECT ContactID,
    FirstName,
    LastName
FROM Person.Contact
WHERE LastName = @LastName
ORDER BY ContactID

Comments

Thanks.. But I want to add the selected rows in a new table. Sat a new table i have created having same columns.. Now i want data retrieved by this sp to be entered in that table.