dj_meier
SSCrazy
Points: 2732
More actions
November 11, 2002 at 2:32 pm
#79259
It there any way to pass a table/array to a stored proc? I know you can return a table from a function. This sample doesn't work, but is there anyway to accomplish the idea?
CREATE PROC pro_test
@tbl TABLE(col1 INT)
AS
SELECT * FROM @tbl
RETURN
-Dan
Simon Sabin
SSCrazy Eights
Points: 8142
November 11, 2002 at 3:42 pm
#441027
No. If you want a table to be available in a sub procedure you need to use temporary tables
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon SabinSQL Server MVPhttp://sqlblogcasts.com/blogs/simons
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply