我刚刚做了这件事:
我想删除所有包含xml字段(不可为空)且ScopeValue列中存在空条目(即零个字符)的行。
有人知道怎么做吗?
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
我想删除所有包含xml字段(不可为空)且ScopeValue列中存在空条目(即零个字符)的行。
有人知道怎么做吗?
declare @x xml; set @x=''; select datalength(@x); select cast(@x as varbinary(max))
- nathan_jr