Advanced Querying

SQLServerCentral Article

Sequential Numbering

  • Article

Needing to number rows with a sequential id is a pretty common request. Sometimes it's because the user hasn't made the transition to 'set based' thinking, sometimes it really is a valid request (more or less!). Greg provides several different techniques to help you achieve sequential numbering.

5 (1)

You rated this post out of 5. Change rating

2003-12-05

11,012 reads

SQLServerCentral Article

Deleting Child Data Based Upon Criteria in the Parent Table

  • Article

New Author! Thom's first article discusses the difficulties you encounter when your database doesn't support cascading deletes (or you've opted not to use it) and you need to delete data in a child table based upon a value in the parent table. Not exactly your run of the mill delete query. Take a look and please rate/comment the article!

You rated this post out of 5. Change rating

2003-06-24

5,264 reads

SQLServerCentral Article

Querying XML files using SQL 2000

  • Article

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!

4 (1)

You rated this post out of 5. Change rating

2002-10-11

11,983 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

Creating Candidate Interest

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Candidate Interest

Logical Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Logical Operators

Evolving Role of Data Professionals in Artificial Intelligence Era

By Amit Rai

Comments posted to this topic are about the item Evolving Role of Data Professionals...

Visit the forum