SQLUSA

Microsoft SQL Server 2005 Best Practices

 

How to find the maximum length of an XML column?

 

Execute the following script in Query Editor to find the maximum, minimum and average length of resumes submitted to AdventureWorks HR:

use AdventureWorks;

select MinLen = min(datalength(resume)),
MaxLen = max(datalength(resume)),
AvgLen = avg(datalength(resume))
from HumanResources.JobCandidate ;

 

American Standard in SQL Server 2005 Training
 
 
SQLUSA.com Home Page