Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

SELECT DATALENGTH(@Value2)

5> DECLARE @Value1 Int, @Value2 Int 6> SET @Value1 = 2 7> SET @Value2 = 2000000000 8> SELECT DATALENGTH(@Value1) 9> SELECT LEN(@Value1) 10> SELECT DATALENGTH(@Value2) 11> SELECT LEN(@Value2) 12> GO -----------           4 (1 rows affected) -----------           1 (1 rows affected) -----------           4 (1 rows affected) -----------          10 (1 rows affected)