Menu
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?
461
The exist() method in the WHERE clause returns 1 (True) if the XML does not include any < Specifications > element. Note the use of the not() function (XQuery). The sql:column() function (XQuery) function is used to bring in the value from a non-XML column. This query returns an empty rowset.
SELECT * FROM yourTableName WHERE yourSpecificColumnName IS NULL OR yourSpecificColumnName = ' '; The IS NULL constraint can be used whenever the column is empty and the symbol ( ' ') is used when there is empty value.
Try this:
DELETE FROM dbo.G_Scope WHERE ScopeValue IS NULL
The SQL Server column would be NULL is if contains no value.
The other possibility would be that the XML is not NULL, but contains an empty string as its value. For that, use this command:
-- The DATALENGTH of an empty XML column is 5
SELECT * FROM dbo.G_Scope WHERE DATALENGTH(ScopeValue) = 5
Does that show you the rows you're interested in?
100
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
