Calling a stored procedure from another stored procedure in SQL 2008

• jbens896

  Newbie

  Points: 9

  More actions

  September 1, 2009 at 1:17 pm

  #214071

  Hello, is it possible to call a stored procedure from another stored procedure using SQL 2008? I heard you might be able to call an assembly but I'm not quite sure how that would work. Any help would be appreciated.

  Thanks,

  Jason

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 1, 2009 at 5:24 pm

  #1047909

  Use books On Line (BOL) the sQL" Server help file and read up on the ccommands EXECUTE and SP_EXECUTESQL

  Execute

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bc806b71-cc55-470a-913e-c5f761d5c4b7.htm

  sp_executesql

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/01c64ab0-9227-475a-a59a-ed80f9333042.htm

  Further read in BOL about sub queries

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c1d634c-fc9f-42e8-ae6f-20b350ef5c90.htm

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]