declare @sqlUpt varchar(max)
select @sqlUpt= ('update tbl_TEMP_pp2 set '+ @RepMonth +'=40 WHERE [Rep CTR Number]=''' + @RepCTRNumber + '''')
exec(@sqlUpt)
Thursday, October 29, 2009
Dynamic Update statement
Labels:
command,
delete,
dynamic sql,
dynamic statement,
optimize sql,
select,
sql server,
update
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment