Today I was trying to debug an error that was occurring in an old .NET 1.1 and SQL Server 2000 application. I needed to find out how a particular value was being set in a DataSet. I knew the value was being returned via a stored procedure, and due to naming conventions this stored procedure [...]
Posts Tagged ‘t-sql’
Find text in stored procedure
Posted: 23rd April 2010 by thegrayzone in DevelopmentTags: SQL, sql server 2000, t-sql
1
Querying SQL Server XML data
Posted: 18th March 2010 by thegrayzone in DevelopmentTags: SQL, sql server 2008, t-sql, xml
Today I was working with data stored using SQL Servers XML datatype. I had to find a way of dealing with the XML data like you would standard relational table data. Here’s how to do it. Sample table and data Firstly, here is a basic table to store the data: CREATE TABLE DummyTable ( DummyTableID [...]