In a sproc that involves creating a copy of a production SQL table for testing, I wanted to reseed the identity of the new table to 1 more t...

In trying to rename a table I encountered the dreaded error about enforced dependencies : Object 'myTable' cannot be renamed beca...

A while back I posted a means to generate random numbers in SQL . I ran across a situation where I need to pick one number randomly from a s...

I needed to create a Google Suggest style search interface for an ASP.NET page. Our site recently obtained licenses to the Telerik c...

I needed a SQL query to insert a range of values randomly into each record of a table variable. The SELECT statement would use the rando...

I needed to modify a SQL function to strip some leading zeros in order to concatenate a string. Part of this process involved dealing with p...

While looking for differing viewpoints on stored procedures vs dynamic SQL , I discovered an article by Frans Bouma from a few years ago, ...

While working feverishly towards meeting a looming deadline on some SQL code, a problem arose. A particular UI that relies on a particular ...

A user reported that a UI being fed by a particular SQL stored procedure was returning the wrong dollar amount for a customer account on an ...

I work on a database which is currently a mix of Microsoft SQL 2000 and 2005 T-SQL code. As part of a project I’m working on, I'm workin...