xml-column

Check if SQL Server 2005 XML field is empty

Hello, I just did this: Delete FROM MyTable WHERE ScopeValue = "" Delete FROM G_Scope WHERE ScopeValue is '' Delete FROM G_Scope WHERE ScopeValue = empty Delete FROM G_Scope WHERE ScopeValue is empty I want to delete all rows with xml field (not nullable) where ScopeValue column has empty entries means zero chars. Anyone knows? ...

Sql Server Xml Column Best Practices

Hi All, What are the best practices for working with Sql server Xml columns to ensure quick performance and also ease of reporting? How do you set up the column? do you leave it as untyped? or associate it with a schema? Does associating the xml column with a schema improve query performance? Our use of xml columns is as follows: ...