Subject | Dynamic SQL |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-07-16T12:56:01Z |
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.
Meghansh.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]
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.
Meghansh.
---------------------------------
Yahoo! Plus - For a better Internet experience
[Non-text portions of this message have been removed]