K Klqpmauk New Member Mar 27, 2013 #1 The following query returns \[code\]<s>false</s>\[/code\]. However I expect it returns \[code\]<s>0</s>\[/code\]. Is it a way to do it?\[code\]declare @b bit = 0declare @xml xml = '<x></x>';select @xml.query('<s>{sql:variable("@b")}</s>')\[/code\]
The following query returns \[code\]<s>false</s>\[/code\]. However I expect it returns \[code\]<s>0</s>\[/code\]. Is it a way to do it?\[code\]declare @b bit = 0declare @xml xml = '<x></x>';select @xml.query('<s>{sql:variable("@b")}</s>')\[/code\]
