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,458 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 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Read the latest Blogs

Forums

SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud

By RK2012

Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...

SQL Master Data Services 2019 - Website keeps prompting for login

By Pete Bishop

I have two SQL 2019 servers running Master Data Services which are continually prompting...

Add more columns to output

By Bruin

$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers