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

    Unanswered: SQL Server 2000 table columns from int to varchar

    Hi all,

    I am currently developing a J2EE web applicaton using struts framework and in my present development environment ,i have an existing MS SQL Server 7 database tables such as Employee,District etc with datas.

    These tables has a column Employee Number and the existing data type is int length 4 and these are not defined as primary keys.

    The current business requirement is to upgrade the database to MS SQL Server 2000 and change the above column from int to varchar
    length 8.

    I can change this directly in the SQL server 7 -Enterprise Manager -Design table view

    However ,I need to know if there any one has faced any realtime issues
    in development due this change.

    Thanks in advance

    Dhana

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    A hypothetical.....

    "It depends"

    I like that answer....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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