sql Cursor

• vinay-492419

  SSC Rookie

  Points: 31

  More actions

  September 19, 2007 at 8:34 pm

  #174912

  Somthing what i want to do

  Declare @var varchar(8000)

  set @var='select col,col2 from sometable'

  DECLARE

  scanprofile CURSOR FAST_FORWARD READ_ONLY FOR

  @var

  OPEN

  scanprofile

  FETCH

  NEXT FROM scanprofile

  -------

  Is it possible to do.....

• Fracn

  Old Hand

  Points: 389

  More actions

  September 20, 2007 at 1:52 am

  #734848

  Hi!

  You can't assing to @var two values (col and col2).

  Try this:

  DECLARE @col (-- insert data type)

  DECLARE @col2 (--insert data type)

  DECLARE scanprofile CURSOR READ_ONLY

  FOR

  select col,col2 from sometable

  OPEN scanprofile

  FETCH NEXT FROM scanprofile INTO @col, @col2