Avoiding Unicode issues when inserting XML into a SQL Database
December 29, 2010If you have to insert XML into a SQL Server (2005+) XML column, there’s three ways of doing it. Perform a raw string insert, which is…
SQL create table reference
December 20, 2010Here’s a quick reference for scripting table creation in SQL server by hand, where the text is readable and pretty rather than an…
Printing all tables in a database with Management.Smo
February 18, 2010The Microsoft.SqlServer.Management.Smo namespace and assembly is used by Management Studio for its interogation of the database. If you have…
Binary upload to SQL Server in
February 24, 2006Download This tool from 2004 is useful if you need to do a quick update of a binary column in a SQL server 2000 table. It could be easily…