Congratulations to Kirby Richter, senior consultant at Magenic Technologies in Golden Valley, Minnesota, and Francis Apel, data warehouse and database administrator at Madison, Wisconsin-based Promega. Kirby won first prize of $100 for the best...
For a long time, C and C++ developers deeply envied their Visual Basic (VB) colleagues for VB's On Error Goto and On Error Resume Next features. At a certain point, the notion of structured exception handling surfaced in C++ applications, but many...
A few months ago, I highlighted the SQL Server 2000 Operations Guide, a handy document designed to help operations teams that are responsible for managing SQL Server's day-to-day operations. The guide offers a wealth of valuable SQL Server...
table.downloadBox {
width: 100%;
border: solid 1px #666;
border-collapse: collapse;
}
table.downloadBox th {
background: #276C9F;
padding: 3px;
color: #fff;
font-size: 14px;
text-align: center;
}
...
Q. Listing 1 creates a table named Tree that represents a hierarchical structure, and Figure 1 shows the hierarchical relationships among the tree's nodes. When I delete a specific row, I want the operation also to delete the entire subtree ...
EDITOR'S NOTE: Share your T-SQL tips and tricks with other T-SQL Solutions readers. Email your ideas (400 words or fewer) to r2r@tsqlsolutions.com. If we print your submission, you'll get $50.
In my SQL Server Magazine article "Treat Yourself ...
Q. I have a column that stores names composed of varying numbers of words. For example, one, two, three, or even more words separated by a single space might constitute a name. I want to update the column values so that the first letter of e...
Why you should use osql.exe when creating database objects
Get comfortable with bits in your system stored procedures