Geek Answers Handbook

Executing SQL Server stored procedure in sql squirrel

I am in ubuntu 9.04 and use sql squirrel as my SQL client. I am connecting to a remote SQL Server. There are several stored procedures in db. I do not know how to carry them out. There is no explicit gui. I used to be in the windows, and I could use the management studio. I can right-click on the stored procedures and give the "Run" command. Do you guys know? Let me know. It will be useful for me. :)

+4
source share
3 answers

Typically, if you want to execute a SQL Server stored procedure, write:

EXEC Your-stored-proc-name-here @param1 = value1, @param2 = value2

and then run this command. As a general rule, you should also use the dbo.StoredProcName notation to avoid confusion / problems.

+7
source 
 EXEC <STOREDPROCNAME> <PARAMLIST> EXEC dbo.GetCandy 'Red',62

Then click on run or equivalent in the editor.

+3
source

I had to fine tune it for the Microsoft SQL Server database (jsqlconnect driver). This worked for me:

 execute <sproc_name> <args>
+1
source

More articles:


All Articles