You need a query like the following:
CREATE PROC dbo.CopyAuthors
SELECT * INTO Northwind.dbo.authors
Dig Deeper on SQL Server Stored Procedures
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ... Continue Reading
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.