USE ...
GO
ALTER PROC foobar
AS
SELECT clientID, Nm FROM client
GO
CREATE TABLE #foos (clientID INT, Nm VARCHAR (255))
GO
INSERT #foos (clientID, Nm)
EXEC foobar
SELECT * FROM #foos
-- DROP TABLE #foos
Subscribe to:
Post Comments (Atom)
Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server. Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
No comments:
Post a Comment