SQL Puzzles

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.

2005-12-21

10,019 reads

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)

2005-11-23

18,643 reads

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)

2005-10-10

22,560 reads

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)

2004-07-14

11,688 reads

Blogs

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap

By

The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

how to lock the record

By KGJ-Dev

Hello, i have a table called Codes and having below columns Declare table Codes(IdCode...

The Redgate Way

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Redgate Way

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers