Scrolling cursor problem

• Jimmy Fallon

  SSC Enthusiast

  Points: 122

  More actions

  February 16, 2005 at 8:21 am

  #66501

  Folks,

   

  Want to declare a scollling cusor in Sql Server 7. Using the following syntax:

  DECLARE <cursor name> CURSOR SCROLL FOR SELECT * FROM <table name>

  I get this message:

  Server: Msg 170, Level 15, State 1, Line 1

  Line 1: Incorrect syntax near 'SCROLL'.

  Have passed the proc to a buddy who is using SQL Server 2000 and he had no problem. Tried another one with 2000 and he had the same trouble as me.

  Can anyone help?

  Thanks in advance.

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 16, 2005 at 9:15 am

  #542573

  I don't have SQL 7 with me now but I think the order should be:

  DECLARE <cursor name> SCROLL CURSOR FOR SELECT * FROM <table name>

  can you test that?

   

  HTH

  
  * Noel

• Jimmy Fallon

  SSC Enthusiast

  Points: 122

  More actions

  February 16, 2005 at 9:58 am

  #542588

  Noel,

  Discovered the problem - was using @ in front of the cursor name - parser did not like that - works without the @

  BTW - your syntax also works but my syntax - without the @ - is Transact-SQL extended syntax (according to Microsoft).

  Thanks for the post.

  Jimmy