what is the equivalent to EXEC(@str)
Posted by:
Dinesh S
Date: July 30, 2007 08:10AM
Hi,
I want to send my query throught the store procedure as a parameter. Is there any method to do this. I know this one in sql server. But not familiar witht mysql to tht extent. Plz any one help me out on this.
Create procedure sp_exec
@strsql as varchar(1000)
As
exec (@strsql)
Go
This is in SQL server. So plz any one help me out in finding the equalent store procedure in mysql server.
Cheers :)
Dinesh
Subject
Views
Written By
Posted
43867
May 07, 2007 06:22AM
17886
May 07, 2007 07:34AM
9717
May 07, 2007 08:53AM
6699
May 07, 2007 09:22AM
4031
May 07, 2007 09:37AM
3803
May 07, 2007 08:30PM
3621
May 08, 2007 04:20AM
3841
May 08, 2007 04:29AM
what is the equivalent to EXEC(@str)
6980
July 30, 2007 08:10AM
4172
July 30, 2007 02:05PM
3898
August 01, 2007 10:06AM
4735
August 02, 2007 10:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.