Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
Sybase
»
T-SQL
»
Coding
»
Executing dynamic SQL in a procedure
In many cases, it is necessary to derive the column name of a query at runtime.
Here's how to do that, in a compiled stored procedure. Note that this is a good method
to use when you want the optimizer to re-process your query at every execution.
-- executing dynamic SQL, in a stored proc
declare @sqlcmd varchar(999),
@monthcolumn varchar(30)
select @monthcolumn = 'sept_sales'
select @sqlcmd =
'update sales_report set ' + @monthcolumn + ' = 5200 ' +
'where salesrep_id = 25 '
execute (@sqlcmd)
if @@error > 0
raiserror 99999 'Error ocurred during report dynamic SQL exec'
|
|
|
Get the latest Rocket99 news and tech tips via
|
