Marty

  • Interests: Playing Guitar, Music Theory

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: )

1,705 reads

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

19 reads

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

query

By sankaripr

Hi i have 3 table that need to find out which id missing two...

Joining 2 select results into a single row

By mtz676

select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...

deleted duplicate post

By mtz676

deleted duplicate post

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers