Technical Article

Display results VERTICALLY in Results window

DESCRIPTION:This procedure will allow you to display results vertically (down) instead of across the screen. It's great when you are dealing with a query that has 50 columns and just a couple of records. LIMITATIONS: * It will be very slow if you are trying to return a lot of records. Works best for queries […]

1 (1)

2007-05-23 (first published: )

1,346 reads

Technical Article

Dynamic and Unique field Select creator

DESCRIPTION:This procedure produces a SELECT statement which explicitly lists all fields for 'tablename' with fieldname and alias as the column name. The SELECT it produces is ready to run or if you need to join several tables just copy the column names off the SELECT it generates. I use this a lot when I create […]

4 (1)

2007-05-22 (first published: )

170 reads

Blogs

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Read the latest Blogs

Forums

Account logging - pwd change/db access change

By Warren Peace

Is there a way to continuously log account changes? For SQL accounts log for...

Starting on Monday

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting on Monday

Charindex values of a substring inside a long sentence

By SQL_Hunt

I need to gather the starting position of the keyword "sql" from a sql...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers