skip to main
|
skip to sidebar
Dynamic SQL
Thursday, October 29, 2009
Dynamic Update statement
declare @sqlUpt varchar(max)
select @sqlUpt= ('update tbl_TEMP_pp2 set '+ @RepMonth +'=40 WHERE [Rep CTR Number]=''' + @RepCTRNumber + '''')
exec(@sqlUpt)
Home
Subscribe to:
Posts (Atom)
Subscribe To
Posts
Atom
Posts
All Comments
Atom
All Comments
Search 2.0
Amazon.com Widgets
height="60" border="0" alt="Join WebHost4Life.com">
About Me
G S Lakmal
View my complete profile