You can use dynamic SQL for this by having the SP accepting a string
parameter and then in the strored procedure execute that string
Create proc ExecMySQL (sql varchar(100))
..If you are trying to pass just a SQL statement to a Stored Procedure it may
lead to security problems.As any statements (like Delete ) can be passed to
Please refer to the following wonderful article for more info.
"Vitamin" <com> wrote in message