Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2008-02-21 : 11:53:24
|
| DECLARE @SQL nvarchar(300)DECLARE @Params nvarchar (200)DECLARE @DOC XML SET @SQL = N'SET @DOCOUT = (SELECT * FROM clnmas FOR XML RAW)'SET @Params = N'@DOCOUT XML OUTPUT'EXEC sp_executesql @SQL, @Params, @DOCOUT = @DOC OUTPUTSELECT @DOCI get an error....Server: Msg 2715, Level 16, State 3, Line 1Column or parameter #-3: Cannot find data type XML.Parameter '@DOC' has an invalid data type.thankstony |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
|
|
|
What am i missing....