| 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 |
|