Here’s a handy little script which tells you what version, service pack and edition of SQL Server you’re running. It’s best to display results as “Text” rather than the “Grid”.
Read more
Tag Archives: SQL Server
Export SQL Server 2005 Xml Column Data to Xml File
January 19, 2009
0 Comments
Xml data stored using the SQL Server 2005 xml data type can be exported a number of ways and you can obviously write a managed stored procedure to do it. However for a quick, one off, type approach you can use the BCP command. The downside of this is that, given the command above you’ll get [...]
Read more
