Subject Dynamic SQL
Author Mahesh Ishwar
Hello All,

Is there a way to execute dynamic SQL from within a stored procedure? For example, I've declared a VARCHAR and form the query in the stored in procedure dependin' upon some logic vatrchar variable ,and then execute it.

It is something like 'Execute Immediate' in oracle & 'Exec' in SQL Server.

Thanx in advance.


Yahoo! Plus - For a better Internet experience

[Non-text portions of this message have been removed]