Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unhappy Unanswered: Migration from SQL 6.5 to SQL 2000

    We are migrating our SQL 6.5 application to SQL 2000 & having some difficulties for one Stored procedure . It is failing . Is there any problem
    with "TINYINT" ? . Same stored procedure is working fine in SQL 6.5.

    We are getting error msg while inserting some rows in following table.

    tbl_sd_cmp_hier_detail
    (

    cmp_hier_id tinyint,
    prnt_cmp_int smallint,
    chld_cmp_int smallint
    )


    i will appriciate any help on this.

  2. #2
    Join Date
    Sep 2003
    Location
    Portland, Oregon
    Posts
    11

    Re: Migration from SQL 6.5 to SQL 2000

    Originally posted by ajayu
    We are migrating our SQL 6.5 application to SQL 2000 & having some difficulties for one Stored procedure . It is failing . Is there any problem
    with "TINYINT" ? . Same stored procedure is working fine in SQL 6.5.

    We are getting error msg while inserting some rows in following table.

    tbl_sd_cmp_hier_detail
    (

    cmp_hier_id tinyint,
    prnt_cmp_int smallint,
    chld_cmp_int smallint
    )


    i will appriciate any help on this.
    There shouldn't be any problem with SQL 2000. I just ran this code in 2000:

    Code:
    USE pubs
    GO
    
    CREATE TABLE tbl_sd_cmp_hier_detail (
        cmp_hier_id  tinyint,
        prnt_cmp_int smallint,
        chld_cmp_int smallint
    )
    GO
    
    INSERT INTO tbl_sd_cmp_hier_detail (
        cmp_hier_id,
        prnt_cmp_int,
        chld_cmp_int
    )
    VALUES (
    	123,
    	456,
    	789
    )
    GO
    
    SELECT * FROM dbo.tbl_sd_cmp_hier_detail
    GO
    I got this:

    Code:
    cmp_hier_id prnt_cmp_int chld_cmp_int 
    ----------- ------------ ------------ 
    123         456          789
    Try the code I pasted here. If that works, there is probably some other problem with the stored procedure.

    Rob

Posting Permissions

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