求救T-SQL变量赋值

[nettt]

如何把这个update变成T-SQL
update dbo.ins_log set end_time=getdate(),ins_row=@ST,state=1 where state=0 and P_name='PAOS_trim_regs'

[ForFumm]

不懂什么意思，
难道你上面的语句不是T-SQL？

[华夏小卒]

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)

[nettt]

我写的不对

[rucypli]

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'

[nettt]

报错
Conversion failed when converting the varchar value 'update dbo.ins_log set end_time=getdate(),ins_row='' to data type int.[Quote=引用 2 楼 js_szy 的回复:]
SQL code
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)
[/Quote]

[ForFumm]

MAYBE?

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