David Poole

Loop through records without using a cursor

I sometimes have to loop through records in a database and perform a specific action on the value that is returned. For example, In the script below I loop through the user tables in sysobjects and simply print them out. This technique is useful when dropping all indices/triggers on a particular table, or adding WITH […]

3 (2)

2001-11-25

9,125 reads

Blogs

Last Week Reading (2019-06-16)

By

Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...

Back with new focus

By

Back with a new focus First let me say wow can’t believe that it...

A Double Day

By

I’m traveling back from Australia today. A few weeks ago I lost a day...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Migration from server to server

By rrizzojr

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...

Temporary data and Differential Backup size

By Thomas Franz

Comments posted to this topic are about the item Temporary data and Differential Backup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers