XP''s

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  January 25, 2005 at 7:22 am

  #92120

   

  I have a query which is using cursor to load data from one database to another.

  When I execute this query in XP runs fine BUT when I run this query in 2000 it insert the same data. for example

  in XP

  id name source_ id

  1 aaa    11

  2 bbb    12

   

  IN 2000

  id  name  source_id

  1  aaa     11

  2  bbb     11

  Does XP and 2000 use any kinds of setting related to Cursor

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738850

  More actions

  January 28, 2005 at 10:36 am

  #539583

  Where is your server loacated? The queries run on the server, not the client, so it wouldn't matter from where you run them.