1. Go to Programmability > Stored Procedures in Object Explorer and then right-click the name of the stored procedure you wish to execute and choose 'Execute Stored Procecure...'
2. In SQL Query window type 'EXEC nameofprocedure param1, param2' etc. (Replacing your real values, of course!)sql
No comments:
Post a Comment