I have a need to handle errors in SQL scripts that i'm working with.<BR><BR>Frequently these errors contain syntax problems and other things like create/drop constraints, not exist..

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

REDMOND, Wash., Sept. 27, 2002 — Join the Professional Association for SQL Server (PASS) as it hosts the PASS Community Summit — Seattle, the only user event exclusively dedicated to Microsoft® SQL ...