There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task.

When a node checks out a work item, do something like (it's been a while since I've done anything with SQL, so the exact syntax is probably different):<BR><BR>update job_table set in_use=TRUE ...

SQL Server 2014 hit its "release-to-manufacturing" milestone today, with Microsoft projecting an April 1 commercial release. The new relational database management system refines technologies ...