Data type variable size in sql

Question

How to find out the size of data in sql. For example, if I declared a variable or column as

declare @test varchar(255)

Then I need the size of the @test datatype variable to display as 255.

EDIT: Now I know how to get it for a column, is there a way for a variable?

+3

Virus 13 Mar At 14:56

1 answer

Mikael Eriksson · Accepted Answer · 2012-03-13T15:09:31+0000

declare @test varchar(255)
set @test = '' --Must assign a value
select sql_variant_property(@test, 'MaxLength')