how to insert your query into stored procedure?

• m.tragedy

  Old Hand

  Points: 360

  More actions

  November 27, 2011 at 4:18 pm

  #247400

  I have a stored procedure. And need to insert a script like "update table set.... where....". if i insert it before the body of procedure, then sql only reads the script. if after then only procedure. what shall i do? sorry for the noob question

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  November 27, 2011 at 4:25 pm

  #1413213

  Can you post your stored procedure and the items you want to incorporate within that SP ? In this fashion someone will be able to assist you....

  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]

• zach.hassler

  SSC Enthusiast

  Points: 119

  More actions

  November 28, 2011 at 4:56 pm

  #1413705

  Put the statements after the AS keyword

  Syntax reference:

  http://msdn.microsoft.com/en-us/library/ms187926.aspx