SQL SERVER TUTORIAL IN DEPTH

The blog is to help users about sql server

Others

LightBlog

Breaking

Saturday 4 January 2014

Len and Datalength in Sql server


Declare @string varchar(20)
select LEN (@string) as StringLength
set @string ='anurag '

--6(o/p) 

Declare @TraillingSpacestring varchar(40)
set @TraillingSpacestring ='anurag '
select DATALENGTH (@TraillingSpacestring) as TraillingSpacestringStringLength

--7(o/p) 


No comments:

Post a Comment

 test