|
|
|
|
|
|
|
Browse Blog Posts by Tags
Sorry, but there are no more tags available to filter with.
-
PowerShell offers support for XML data directly though its [xml] datatype and this article is going to look at that. First of all to make use of the builtin [xml] datatype just prefix a variable name with [xml] when you assign something to it. PS C:\demos> [xml]$order = "<order customer='joe'>...
-
Comparing XML in SQL Server 2005 Xml is not text so a literal compare of two xml documents may lead to a false negative, that is it may indicate that two documents are not equal when in fact they are. For example these two xml documents are the same: <item x="1" y="2"/> <item y="2" x="1"/>...
-
How much space does xml cost in SQL Server 2005? This question seems to come up a lot because xml has a lot of meta data in it and to top it off SQL Server saves the xml data type using UTF-16 encoding. This is, at least for xml that is mostly ascii type characters, up twice as much space as the encoding...
-
I saw a wish list blogged at http://omnibuzz-sql.blogspot.com/2006/07/next-version-of-sql-server-wish-list.html. It wanted a sql function that would evaluate an string arithmetic expression in the next version of SQL Server. It turns out that function is already available, sort of, in T-SQL on SQL Server...
|
|
|
|
|
|