Results 1 to 15 of 15
  1. #1
    Join Date
    Feb 2007
    Posts
    7

    Question Unanswered: storing data lager than 8000 charactors in mssql server 2000

    HI

    i want to save data larger than 8000 charactors in a colomn

    is there any way to do it in mssql server 2000 desktop addition

    plz help me

    Thanks in advance

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    use text/ntext type field.

  3. #3
    Join Date
    Feb 2007
    Posts
    7

    storing data lager than 8000 charactors in mssql server 2000

    but while setting column data type as text. ntext there is no option to change its length ,....

    it default length that mssql server shows is only 16 chars

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    just ignore that business about the length being only 16 chars

    the length is variable, and goes up to 2 gigabytes (1g for ntext)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2007
    Posts
    7

    storing data lager than 8000 charactors in mssql server 2000

    hi


    as per given suggestion i use @requestList text(100000)

    the error 131 is came... plz set the size upto 8000 chars ....

    any other suggestions.........

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    VARCHAR and CHAR require a length, but TEXT, NTEXT and BLOB do not
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2007
    Posts
    7

    storing data lager than 8000 charactors in mssql server 2000

    in that case if i dont mention its size then
    error 257 is recieved

    cannot use empty object or column name use a single space if nesccessay


    ............

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    would you mind please showing the statement that gives you this error
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Feb 2007
    Posts
    7
    CREATE PROCEDURE processClientRequest(@requestList text)as
    begin
    /..
    body
    ./
    end

  10. #10
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    there is no problem in the code given here. there might be other lines that is causing the error.....

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Text can not be passed as a parameter to a procedure. At least not until SQL 2005, when varchar(max) becomes available.

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Forget text...M$ is basically abondoning it...

    Create a child table with the key and use many rows of varchar(n)


    But...

    What are you storing?
    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.

  13. #13
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    Quote Originally Posted by MCrowley
    Text can not be passed as a parameter to a procedure. At least not until SQL 2005, when varchar(max) becomes available.
    not really. text can be passed to SP as param in SQL 2000 itself...

  14. #14
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I'll be darned. It can be done. Guess I have been too stuck in best practices to even try it ;-).

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Yes but it can't be declared as a datatype

    There are so many reason not to use text, ntext, ect
    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
  •