SQL Puzzles

SQLServerCentral Article

SET ROWCOUNT and TVFs

  • Article

SQL Server 2000 has table valued functions that are very useful in many ways. However when you try to limit results with the ROWCOUNT setting, you can end up with some strange results. Peter He brings us a comprehensive look at some of the unpredictable results that you can get and how to code around them.

You rated this post out of 5. Change rating

2005-12-21

10,131 reads

SQLServerCentral Article

Quick Hints for using the RAISERROR Command

  • Article

SQL Server 2000 error handling isn't the most mature system for dealing with unexpected events. It has been much enhanced in SQL Server 2005, but many people will be using SQL Server 2000 for a long time. RAISERROR is one of those functions that can really aid in troubleshooting, but is often underutilized. David Poole brings us some hints on how this can help you out in your code.

4.6 (5)

You rated this post out of 5. Change rating

2005-11-23

19,559 reads

SQLServerCentral Article

Reporting a menu structure using a recursive UDF

  • Article

Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.

5 (2)

You rated this post out of 5. Change rating

2005-10-11

8,795 reads

SQLServerCentral Article

An Audit Trail Generator

  • Article

Auditing is becoming more and more important in many SQL Server environments. DBAs are being tasked with setting up, maintaining, and reporting on audit data. Author Leo Peysakhovich brings us one of his solutions to automatically generate an audit trail for your data.

4.83 (6)

You rated this post out of 5. Change rating

2005-10-10

23,004 reads

SQLServerCentral Article

An Is Null Gotcha

  • Article

In T-SQL you should use the IS NULL keywords to test for a null value. But David Poole runs into a strange gotcha in one of his applications where he is testing for a null value. It's an interesting read following Sherlock Poole around on his hunt to find an error.

4.75 (4)

You rated this post out of 5. Change rating

2004-07-14

11,698 reads

Blogs

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Read the latest Blogs

Forums

AD, powershell and ssis

By stan

Hi, i have a requirement that involves visiting multiple folders in AD for active,...

File date from Extended Event .xel files

By Michael L John

I know this, but I do not remember it. I have scoured by saved...

SSMS gets very messy

By oRBIT

At work we have quite a few databases that I'm frequently browsing. This is...

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers