SQL Server Performance

varcar

Discussion in 'General DBA Questions' started by issolla, Jan 8, 2004.

  1. issolla New Member

    How to assign a variable which will accept more than 8,000 characters(I need unlimited) with varcar function. It should take exact space though the option is unlimited like varcar.

    Thanks
    john
  2. FrankKalis Moderator

  3. satya Moderator

    If not consider TEXT datatype or TABLE datatype to work as a variable in the database.
    REfer to books online for more information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page