Database Migration, Comparision and Synchronization Tools
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

February 2010 - Posts

XQuery Lab 52 – A More Intuitive way of reading an RDF document

After reading XQuery Lab 51 , my friend and database expert Brad Schulz send me a note showing another way of achieving the same results. The approach he suggested was much cleaner than my version. My code used the following expression in the WHERE clause...
by Jacob Sebastian on 02-25-2010 | 594 Views

Why does Excel 2007 prompt for repair when opening a document stored in SQL Server 2008 FILESTREAM Column?

This post looks closer into a common problem many people may have faced while storing Microsoft Office documents into the FILESTREAM column of a SQL Server database....
by Jacob Sebastian on 02-18-2010 | 1,203 Views

XQuery Lab 51 – Querying an RDF document using TSQL and XQuery

This installment of XQuery Labs presents a script that reads information from an RDF document using TSQL and XQuery....
by Jacob Sebastian on 02-16-2010 | 973 Views

How to generate CDATA and NAMESPACE Declarations using FOR XML EXPLICIT

I was asked this question in one of the SQL Server forums recently. The OP wanted to generate an XML document with CDATA sections and NAMESPACE declarations. SQL Server 2005 introduced WITH XMLNAMESPACES() which is very handy to generate namespace declarations...
by Jacob Sebastian on 02-06-2010 | 907 Views

Copyright © Beyondrelational.com