Column_Gitter

This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names of the columns, the names with their datatypes, the list of columns with each one set to an identically-named variable, and a list of variables with the same names as the […]

2003-08-12

197 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Multiple rows of same site with different managers for each - how to pivot

By andrewjmdata

Hi, I have a table of sites where the there are multiple site names...

Inner Join creating duplicates in SQL along with Group By

By lynhudson1

I have two datasets, where I would like to join and then group by...

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers