measure twice, cut once.

Blog Post

OPENJSON and CROSS APPLY

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...

2020-06-24 (first published: )

3,031 reads

Blog Post

OPENJSON and an Alias

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

44 reads

Blogs

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Group By Starting Characters

By

I was chatting with Jeff (b|t) on my team yesterday and the context escapes...

Daily Coping 22 Oct 2021

By

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

Read the latest Blogs

Forums

Maybe It Is DNS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Maybe It Is DNS

Finding all logins that can alter DDL

By webrunner

Hello experts, Is there a ready-made query out there that I could run on...

Insert records with a where

By saintor1

I want to insert record job allocations only for selected jobs I know the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers