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)

You rated this post out of 5. Change rating

2007-05-23 (first published: )

1,952 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)

You rated this post out of 5. Change rating

2007-05-22 (first published: )

171 reads

Blogs

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

PGSQL Phriday #009: On Rollback

By

The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...

Read the latest Blogs

Forums

puzzeled with "exec sp_cursor 180150007,40,1"

By Johan Bijnens

I've noticed in one of our applications a cursor uses operation 40 and that...

Not wanting to use a Cursor, but...

By jwilkerson@valleymetro.org

Ok, need someone to talk me off the cursor ledge on this one. I...

Better Communication Through Less Messaging

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Communication Through Less Messaging

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers