Char Vs Varchar
Few example showing the difference between char and varchar:
DECLARE @CharName Char(30) = 'Yogesh Chandra Upreti',
@VarCharName VarChar(30) = 'Yogesh Chandra Upreti'
SELECT DATALENGTH(@CharName) CharSpaceUsed,DATALENGTH(@VarCharName) VarCharSpaceUsed
DECLARE @FirstName Char(20) = 'YogeshChandra',
@LastName Char(20) = 'Upreti'
IF @FirstName + ' ' + @LastName = 'YogeshChandra Upreti'
PRINT 'I was Expecting'
ELSE
PRINT 'Surprise to me ...'
SELECT @FirstName + ' ' + @LastName AS Name, len(@FirstName + ' ' + @LastName) AS Length
DECLARE @FirstName VarChar(20) = 'YogeshChandra',
@LastName VarChar(20) = 'Upreti'
IF @FirstName + ' ' + @LastName = 'YogeshChandra Upreti'
PRINT 'I was Expecting'
ELSE
PRINT 'Surprise to me ...'
SELECT @FirstName + ' ' + @LastName AS Name, len(@FirstName + ' ' + @LastName) AS Length
No comments:
Post a Comment