Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Sqlserver - Query to Get Size of the data

March 17 2013 , Written by Balavardhan Reddy Published on #SQL Server2005

Query to get the size of a column data for each row.

Select DATALENGTH(<<ColumnName>>) from <<TableName>>

Query to get the size of a column data for each group.

Select DATALENGTH(<<ColumnName>>), <<Column Name>> from <<TableName>> Group by <<Column Name>>

Share this post

Repost 0
To be informed of the latest articles, subscribe:

Comment on this post