KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to pass a TABLE variable to the sp_executesql procedure: DECLARE @params NVARCHAR(MAX) SET @params = '@workingData TABLE ( col1 VARCHAR(20), col2 VARCHAR(50) )' EXEC sp_executesql @sql, @params, @workingData I get the error: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'TABLE'. I tried omitting the column specification after 'TABLE'. I also tried to declare the table as a variable inside the dynamic SQL. But no luck... Seems to me that TABLE variables aren't allowed to be passed as parameters in this procedure?. BTW: I'm running MSSQL2008 R2. I'm not interested in using a local temp table like #workingData because I load the working data from another procedure: INSERT INTO @workingData EXEC myProc @param1, @param2 Which I cannot do directly into a temp varaible (right?)... Any help appreciated!
Tags (comma-separated)
Save Edits
Cancel