How to execute MSSQL Stored Procedure from IIS
Store procedure in MSSQL can be executed from IIS through the use of a command called Execute.
Step 1
Open up your browser and then enter the following command in the address bar.
http://compact/northwind?sql=execute+Demostoredprocedure&root=root
Your browser will retrieve execute a stored procedure called DemoStoredProcedure and return results to your browser. If you have not create that stored procedure please create it now.
The output from your browser would look something like this.
No comments:
Post a Comment