Microsoft SQL Server

Microsoft SQL Server

#sql-server

1

1: Microsoft SQL Server

2

2

2

Examples

2

INSERT / SELECT / UPDATE / DELETE:

2

5

5

6

6

7

7

,

8

UPDATE Specific Row

9

9

9

10

11

12

TRUNCATE TABLE

12

13

Row Count

14

2: bcp ( )

15

15

Examples

15

( )

15

3: COALESCE

16

16

Examples

16

COALESCE -

16

Coalesce

16

17

4: DBCC

18

Examples

18

DBCC

18

DBCC

19

DBCC

19

DBCC

20

DBCC

20

5: DBMAIL

21

21

Examples

21

21

21

HTML-

21

6: FileStream

23

23

Examples

23

23

7: FOR XML PATH

24

24

Examples

24

Hello World XML

24

24

XPath

24

FOR XML PATH

26

8: JSON Sql

28

28

28

28

Examples

28

JSON FOR JSON

28

JSON

29

JSON, CROSS APPLY OPENJSON

29

JSON

30

JSON, FOR JSON

32

JSON OPENJSON

32

9: MERGE

34

34

34

35

Examples

35

MERGE / /

35

CTE

36

MERGE

36

-

36

EXCEPT

38

10: OPENJSON

39

Examples

39

: JSON

39

JSON

39

JSON

40

JSON

40

JSON

41

11: ParseName

43

43

43

Examples

43

ParseName

43

12: PHANTOM

44

44

44

Examples

44

READ UNCOMMITTED

44

13: PIVOT / UNPIVOT

46

46

46

Examples

46

-

46

PIVOT & UNPIVOT (T-SQL)

47

PIVOT

49

14: Schemas

51

Examples

51

51

51

51

51

15: SCOPE_IDENTITY ()

52

52

Examples

52

52

16: SQL Server Evolution (2000 - 2016)

53

53

Examples

53

SQL Server 2000 - 2016

53

17: SQLCMD

57

57

Examples

57

SQLCMD.exe

57

18: UNION

58

Examples

58

58

19:

61

Examples

61

Scan vs Seek

61

20:

62

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

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

Google Online Preview   Download