Microsoft SQL Server

Microsoft SQL Server

#sql-server

1

1: Microsoft SQL Server

2

2

2

Examples

2

INSERT / SELECT / UPDATE / DELETE :

2

4

4

5

5

5

5

6

6

.

7

7

7

8

9

TRUNCATE TABLE

9

9

9

2: Azure SQL

11

Examples

11

Azure SQL

11

Azure SQL

11

Azure SQL

11

Elastic Azure SQL

12

3: bcp ( )

13

13

Examples

13

( )

13

4: CASE

14

14

Examples

14

CASE

14

CASE

14

5: CLUSTERED COLUMNSTORE

15

Examples

15

CLUSTERED COLUMNSTORE

15

15

CLUSTERED COLUMNSTORE

15

6: CREATE VIEW

16

Examples

16

CREATE VIEW

16

16

INNER JOIN

16

CREATE INDEXED VIEW

17

17

18

7: DBCC

19

Examples

19

DBCC

19

DBCC

19

DBCC

20

DBCC

20

DBCC

21

8: DBMAIL

22

22

Examples

22

22

22

HTML

22

9: FOR XML PATH

24

24

Examples

24

Hello World XML

24

24

XPath

24

FOR XML PATH

25

10: GROUP BY

27

Examples

27

27

GROUP

28

,

28

30

ROLLUP CUBE GROUP BY

31

11: JSON

33

Examples

33

JSON

33

JSON

33

JSON

33

JSON

33

JSON

34

JSON JOIN

34

JSON

34

12: JSON

35

Examples

35

JSON

35

JSON PATH

35

JSON ( )

35

INCLUDE_NULL_VALUES

36

ROOT

36

JSON AUTO

36

JSON

37

13: JSON

38

Examples

38

JSON

38

JSON

38

JSON JSON

38

FOR JSON JSON

39

FOR JSON JSON

39

14: JSON SQL

40

Examples

40

JSON

40

JSON ISJSON .

40

JSON

40

JSON

40

JSON

41

15: Microsoft SQL Server Studio

42

Examples

42

42

42

42

16: MS SQL Server DDL

45

Examples

45

45

45

45

45

46

17: NULLs

47

47

47

Examples

47

NULL

47

ANSI NULLS

48

ISNULL ()

48

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download