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

2,618 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

42 reads

Blogs

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

SSMS & Excel - Copy Paste - DateTime Columns

By AMCiti

Dear Group: I am not sure if this is a T-SQL / SSMS issue,...

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers