Browse by Tags

All Tags » General (RSS)
Stored Procedure parameters
Here’s some more SQL that writes SQL. One way of debugging a stored procedure is to chop off the CREATE PROCEDURE at the top and replace it with DECLARE and SET statements for the variables, then step through the stored procedure. The following SQL gives...
Posted 22 January 2008 07:23 PM by Danny | with no comments
Filed under:
SQL Internals Viewer on LearnSQLServer.com
Scott Whigham at LearnSQLServer.com has featured SQL Internals Viewer in a new series of video tutorials. The site has a whole range of video tutorials on SQL Server covering the basics right up to advanced topics. I've seen the videos and they are a...
Posted 12 January 2008 05:46 PM by Danny | with no comments
Filed under:
FOR XML and back again
I’ve used the 2005 XML features for a few things now and I’m getting to quite like it. One thing I’ve found is that it is a lot easier to get data into XML than it is to get it back out again. The following is a stored procedure that given an XML variable...
Posted 06 January 2008 10:17 PM by Danny | 1 comment(s)
Filed under: ,