How to execute a stored procedure in SQUIRREL?

• chandrasekaran.ganapathy

  SSCommitted

  Points: 1738

  More actions

  August 4, 2010 at 9:50 am

  #387500

  Hi

  Can any one help me to resolve this problem.

  I am customising the SQL Query in to SQUIRREL.

  I know that we can execute the stored procedure in SQL server:

  EXEC sp_name

  If i give the same in SQUIRREL:

  EXEC is not key word.

  I tried call also (begin and end also). It is not working. Can any one let me know this?

• Henry Treftz

  SSCarpal Tunnel

  Points: 4207

  More actions

  August 4, 2010 at 10:11 am

  #1202185

  Take a look at

  http://squirrel-sql.sourceforge.net/paper/SQuirreL_us.pdf

  And search for Stored Procedure, the second entry seems to indicate you need the SQL Server plugin to generate the correct syntax for JDBC

• darren 42235

  Valued Member

  Points: 51

  More actions

  February 15, 2012 at 3:51 am

  #1447232

  Hi Are you still using SQuirreL?

  I would like to hear from you on what you think.

  Kind Regards

  Darren

  darren@ngssoftware.com