Home Forums SQL Server 7,2000 General UPDATE Query problem RE: UPDATE Query problem
gregj
Old Hand
Points: 346
More actions
July 29, 2003 at 8:44 am
#467505
To get the length of a column, you can use the following function:
COLUMNPROPERTY( OBJECT_ID('tablename'),'columnname','PRECISION')
It seems the query optimizer should evaluate it only once instead of for every row.