Cursors

• Nisha N.Kumar

  Ten Centuries

  Points: 1100

  More actions

  May 12, 2008 at 6:16 am

  #70365

  Can we have multiple tables in the same cursor?

  Also I want to know where we will use stored procedures and functions....I mean in what scenario they are used....Both of them can be used for similar purpose...

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  May 12, 2008 at 10:17 pm

  #814219

  Yes, a cursor can have a join to multiple tables in it... but using a cursor is usually a mistake.

  Store procs don't have to return anything... functions do.

  These are sweeping subjects... recommend you lookup stored procs and functions in Books Online and read about them a bit.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  May 13, 2008 at 3:17 am

  #814301

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

  http://databases.about.com/od/sqlserver/a/storedprocedure.htm

  Just go through the above link,I hope you will get some idea.

  karthik