USE [jxc];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
ALTER PROCEDURE [dbo].[测试Test]
@SN NVARCHAR(20) = NULL,
@GC NVARCHAR(50) = NULL,
@BPFH NVARCHAR(50) = NULL
AS
BEGIN
DECLARE @SQL NVARCHAR(500);
SET @SQL = 'SELECT * FROM [SERVER3,1440].jinxing.dbo.T_JGJH_AP_S as T WHERE 1=1 AND T.GYLX = ''WX'''+
' AND NOT EXISTS( SELECT 1 FROM [jxc].[dbo].[DD_wxj] as W WHERE W.图号 = T.WLBM)';
IF(ISNULL(@SN,'')<>'') SET @SQL=@SQL+' AND T.WLBM LIKE '+''''+@SN+'%''';
IF(ISNULL(@GC,'')<>'') SET @SQL=@SQL+' AND GC = '''+@GC +'''';
IF(ISNULL(@BPFH,'')<>'') SET @SQL=@SQL+' AND BPFH='''+@BPFH+'''';
EXEC (@SQL);
END;
以上源码:在jxc中的存储过程"[测试Test]",里面的SERVER3是其它服务器,在jxc上设置了对此的链接服务器,jxc上调用这个" [SERVER3,1440].jinxing.dbo.T_JGJH_AP_S "可以正常查询到数据.就是运行整个存储过程报错了,研究了很久没解决,希望大牛指导下问题点在哪儿.我测试了下有""' AND NOT EXISTS( SELECT 1 FROM [jxc].[dbo].[DD_wxj] as W WHERE W.图号 = T.WLBM)';""这部分就会报错
结果:
消息 102,级别 15,状态 1,第 3 行
'?' 附近有语法错误。
(1 行受影响)