There are several ways of storing XML documents in SQL Server table.
One way is to use a table with datatype varchar(max) or nvarchar(max).
another option is to use XML data type column
or you can use varbinary(max)
if you are using SQL 2012, then there is yet another option: use filetable and filestream
Let’s look quickly at these options:
Continue reading […] Storing XML in SQL Server – note to self […]
Have you heard the news?
Soon there will be a new addition to the Redgate’s Deployment Suite for Oracle. The Source Control for Oracle is coming to be a part of it.
So far the Deployment suite has the capabilities of comparing schemas, data and creating schema deployment scripts, but very soon the new member of the
Continue reading […] A new addition to the Deployment Suite for Oracle: Source Control for Oracle […]