34,576
社区成员
发帖
与我相关
我的任务
分享
DECLARE @ExamList XML,@SHIPCODE VARCHAR(10),@NAME VARCHAR(20)
SET @SHIPCODE=''
SET @NAME=''
DECLARE @SQL NVARCHAR(4000)
SET @SQL=N'SET @ExamList =
(SELECT ID,CODE
FROM OPENQUERY(ORA1,''SELECT *
FROM SCOTT.EMP WHERE ID='+ @SHIPCODE + ' AND CODE='''''+ @NAME+''''' '')
FOR XML PATH (''ExamC''),ROOT(''ExamList''))'
--PRINT @SQL
EXEC SYS.SP_EXECUTESQL @SQL,N'@ExamList XML OUT',@ExamList OUT
--SELECT @ExamList
那就需要动态执行了