是因为引号的问题,改成下面的应该就可以了。
EXEC('INSERT INTO dbo.jt_CLAJRK1
SELECT * FROM dbo.jt_CLARKD1 WHERE CGD=''AA''')
EXEC('INSERT INTO dbo.jt_CLAJRK1
SELECT * FROM dbo.jt_CLARKD1 WHERE CGD=''AA''')
调试欢乐多
SELECT * FROM dbo.jt_CLARKD1 WHERE CGD=''AA''')