Skip to content

Instantly share code, notes, and snippets.

@sbealer

sbealer/examples.sql

Created September 22, 2017 22:38
Show Gist options
  • Save sbealer/054af69fea4f9bbf1ae17b6d5925fdd1 to your computer and use it in GitHub Desktop.
Save sbealer/054af69fea4f9bbf1ae17b6d5925fdd1 to your computer and use it in GitHub Desktop.
Download ZIP
New & Notable SQL Server 2016 enhancements!
Raw
examples.sql
JSON stuff: https://gist.github.com/sbealer/c2d4585570d9334861115c50208fb637
Quick if exists drops!
drop table if exists dw.this_table_doesnt_exist;
Create or Alter!
create or alter view test_view AS
select 'testing new create or alter syntax' as val;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment