how to know space used per column

I know I can use sp_spaceused to check space used per table.
However, how can I know space used per column?SELECT SUM(DATALENGTH(<column_name> )) should get you pretty close to that.
Jacco Schalkwijk
SQL Server MVP
"Guoqi Zheng" <no@.sorry.com> wrote in message
news:eMxBo4RBFHA.608@.TK2MSFTNGP15.phx.gbl...
>I know I can use sp_spaceused to check space used per table.
> However, how can I know space used per column?
>

how to know database space on SQL 6.5 by command line

Hello,
i'll write a scripte to check my databases.
My need know the space use by the database & device,
the same for the space free.
Can you help me..
ThanksHi
I don't have 6.5 access at the moment, but you may want to check out if
sp_helpdb <dbname> run from isql, gives you something you can work with.
John
"bfav" <bfav@.ch.ibm.com> wrote in message
news:087701c3506d$49c01bd0$a001280a@.phx.gbl...
> Hello,
> i'll write a scripte to check my databases.
> My need know the space use by the database & device,
> the same for the space free.
> Can you help me..
> Thanks