views:

503

answers:

2

i'm in ubuntu 9.04 and using sql squirrel as my sql client. i connect to a remote SQL Server. There are some stored procedures in the db. I don't know how to execute them. No explicit gui. Earlier i was in windows and i could use management studio. I can right click on stored procedures and give Execute. You guys have any idea? Let me know. It will be helpful for me. :)

+1  A: 
EXEC <STOREDPROCNAME> <PARAMLIST>

EXEC dbo.GetCandy 'Red',62

Then hit execute or the equivalent in your editor.

StarShip3000
DARN - beat me by 51 seconds! :-)
marc_s
+1  A: 

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

EXEC (stored proc name) @param1 = value1, @param2 = value2

and then execute that command. Typically, you should also use the "dbo.StoredProcName" notation to avoid any confusion / problems.

marc_s