Finding Length of data
in column in Bytes in SQL SERVER
Returns the number of bytes used to represent any expression.
Here the “datalength “
funcion helps to find the size of the data in the column. For example data
in the column is “ARUN” then it takes 4 bytes, because one charater takes
one byte, likewise you can calculate for all datatypes.
--
Created table with Primary Key
CREATE
TABLE MyOrdersPrimary
(
OrderId
int PRIMARY
KEY NOT
NULL,
ProductName varchar(20)
);
--
Inserted some records
insert
into MyOrdersPrimary
values (1,'Samsung')
insert
into MyOrdersPrimary
values (2,'Nokia')
select
datalength(ProductName)
as Bytes,
* from
MyOrdersPrimary
Thanks