varchar

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: payyans (anonymous_at_discussions.microsoft.com)
Date: 08/29/04

Next message: David E Herbst: "Re: How to handle/strip out Quotes around string columns that can be n"
Previous message: Steve Kass: "Re: compare EXISTS with IN using Execution Plan"
Next in thread: Adam Machanic: "Re: varchar"
Reply: Adam Machanic: "Re: varchar"
Messages sorted by: [ date ] [ thread ]

Date: Sun, 29 Aug 2004 14:58:25 -0700

SQL Server 2000
---------------
Is there any disadvantage in defining the data type as
varchar(8000) instead of varchar(200) for the varchar
columns of my table? I know that the storage size of
varchar is the actual length in bytes of the data entered.
So there should not be any difference as far as the
storage is concerend. But, does SQL Server use the
declared length in the memory when working with such
columms?

Thanks in advance,
payyans

Next message: David E Herbst: "Re: How to handle/strip out Quotes around string columns that can be n"
Previous message: Steve Kass: "Re: compare EXISTS with IN using Execution Plan"
Next in thread: Adam Machanic: "Re: varchar"
Reply: Adam Machanic: "Re: varchar"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: SQL Datatypes
... stored as a varchar, data that should be stored as a float is stored ... The exact validation is different depending on data type. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Data type in audit record
... Rather than have an audit table mirroring ... pk_value (varchar) - primary key of the changed record. ... I'm not sure what data type the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)
Re: Any workaround for row size > 8060?
... Does Centura support SQL Server? ... will need to use the text data type if you need to store more than 8060 ... the same way as a varchar due to the nature in the way they are stored. ...
(microsoft.public.sqlserver.server)
Re: Any workaround for row size > 8060?
... > We're converting Oracle databases to SQL Server. ... I have one TEXT column and various varchar 4000 and varchar 2000 columns. ... > Can we have more than one column as TEXT data type? ...
(microsoft.public.sqlserver.server)
Re: Conversion error
... You canimport both types of data into a varchar column now. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >>character data has to be one or the other. ...
(microsoft.public.sqlserver.dts)