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,126 reads

Blogs

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

Read the latest Blogs

Forums

SQL Tamagotchi! Mini-Servers as Database Pets

By Phil Factor

Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...

SQL 2014 (or any other versions) Standard - ~Embedded Licensing~

By Warren Peace

Anyone have any insights on how this licensing works and what the "Use Rights"...

SSIS - Adding Columns to existing table and load data

By sunshine

I am working in SSIS (Sql server version 2012) , I have a requirement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers