Passing Parameters to cursors in MSSQL

• nivs

  Valued Member

  Points: 57

  More actions

  October 25, 2002 at 2:09 am

  #80042

  Hi,

  I am facing a problem in migrating a cursor declarartion from Oracle to

  MSSQL

  This is in Oracle

  cursor cursSku (prId IN NUMBER) is

  select * from sku where p_id = prId;

  Has to be migrated to MSSQL,Pls Help

  Thanks

  Nivedita

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  October 27, 2002 at 12:04 pm

  #439543

  Not possible, you have to declare the cursor every time.

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons