Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

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'

Sybase : Related Topics

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2019 Stoltenbar Inc All Rights Reserved.