Browse by Tags

All Tags » SQL (RSS)
Sorry, but there are no more tags available to filter with.

[SQL] Tools I Can't Live Without Right Now by jdanforth

I've been doing loads of SQL crunching lately, staging, versioning, and preparing for a pretty large migration job later this year which involves a great deal of schema and data changes in SQL Server 2005. A tool which has been saving me a great deal...
Filed under:

[SQL] Finding the Boss with Hierarchical Queries by jdanforth

Never thought I was going to blog about SQL... but I'm doing this mostly for myself because I need to use this at work on monday. I know enough to do database design and whip up a few necessary stored procs, but when it comes to functions and the...
Filed under:

[SQL] Using a Variable TOP Clause by jdanforth

This is a simple one, but still worth mentioning. Say you want to select a variable number of rows in a SELECT statement and don't want to use "dynamic SQL" to do that but rather use a SQL Parameter - no problems. In SQL Server 2005 you...
Filed under:
More Posts