27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE dbo.PR
@ST INT
AS
BEGIN
UPDATE dbo.ins_log set end_time=GETDATE(),ins_row=@ST,state=1
WHERE state=0 and P_name='PAOS_trim_regs'
END;
EXEC PR @PAR
declare @st varchar(10)
set @st='a'
update dbo.ins_log
set end_time=getdate(),ins_row=@ST,state=1
where state=0 and P_name='PAOS_trim_regs'
DECLARE @S VARCHAR(1000)
SET @S='
update dbo.ins_log
set end_time=getdate(),
ins_row='''+@ST+''',
state=1
where state=0 and P_name=''PAOS_trim_regs'''
EXEC(@S)