27,579
社区成员
发帖
与我相关
我的任务
分享
--参照
DECLARE @i INT,@sql NVARCHAR(MAX)
SET @sql='set @i=1'
EXEC sp_executesql @sql,N'@i int out',@i OUT
SELECT @i
--你的
declare @sqldf nvarchar(500),@inid int
set @sqldf= 'select @inid=max(inid) from U8LOC.UFDATA_123_2018.dbo.GL_accvouch'
EXEC sp_executesql @sqldf,N'@inid int out',@inid OUT
SELECT
@inid = MAX(inid)
FROM
U8LOC.UFDATA_123_2018.dbo.GL_accvouch;