CHECKSUM column: Byte Length? 2

[LFCfan]

Does anyone know how to calculate the byte length/storage space of a field which is a checksum of another field? I need to calculate the maximum row length of various tables and I can't find anything in BOL about checksum column lengths

Just in case this is needed, the relevant part of the table definition is

CREATE TABLE MyTable(
...
[AccNumber] [varchar] (20) COLLATE Latin1_General_BIN NOT NULL ,
[csAccNumber] AS (checksum([AccNumber])) ,
...
)


Thanks
Maria

 

[tlbroadbent]

Checksum is an INT datatype - 4 bytes. Verify with the datalength function. Select datalength([csAccNumber]). Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[LFCfan]

Thanks loads Terry,

I didn't know about the datalength function and it's going to be very useful to me for the task I've been set!

Maria