Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: Migration Problems: 7 to 2000

    Not surprisingly, SQL Server 2000 seems to do some things differently than did version 7. In general, it seems to be less forgiving of sloppiness, such that queries that probably shouldn't have worked in 7 (but did) no longer work in 2000.

    I've found at least three such things:
    1) Default sort is different.
    2) Concatenating a varchar column that contains a value with a column containing a null now produces a null.
    3) I may have some old stored procs held over from 6.5 or something. They checked a bit column for -1. These worked in SQL 7. Even though the column actually contained a 1. They no longer work in 2000.

    My question is this: Is there anywhere I can go to find a list of these differences, so I can make preventive changes to my SP's before I move them to 2000? Or do I just have to move them and fix the problems as they occur?

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Migration Problems: 7 to 2000

    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Feb 2003
    Posts
    2
    Thanks! That's just the kind of thing I was looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •