Script to Return a Transposed Data Row

I often do the following when administering databases "select * from Table where PrimaryKey=value" and find the output in Query Analyzer is inconvenient to view when the table has many wide columns (which is often the case). This script returns a single entry from a table but "transposed" so that the data flows down the […]

2005-11-10 (first published: )

222 reads

Blogs

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Investigating Azure Databricks

By

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Convert smallint to Date

By PJ_SQL

Hello! I have column in SQL 2012 DB of datatype smallint. Could you please...

Managed Instance Error Creating Recurring Schedule - BUG???

By DBADave

When we try to create a SQL Server Agent job schedule that has a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers