SQL Server Performance

regarding procedures

Discussion in 'General Developer Questions' started by raviatvns, Mar 25, 2011.

  1. raviatvns New Member

    I have one seperate table for state and another table for district.. having the foregin key relation in the district table. I wana find the district names for the corresponding state. Is this possible to do with the stored procedures? is there a way that procedure could return multiple rows at a time.
  2. satya Moderator

  3. FrankKalis Moderator

    A Stored Procedure is just a shell for one or more SQL statements. so, yes, first write the query and then wrap it inside a stored procedure and maybe parameterise it. Quite straight-forward.

Share This Page