Microsoft SQL Server

[Pages:310]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

null null .

49

COALESCE ()

49

NULL

49

18: OPENJSON

51

Examples

51

: JSON

51

JSON

51

JSON

51

JSON

52

JSON

52

19: OVER

54

54

54

Examples

54

OVER

54

55

55

NTILE

56

20: SCOPE_IDENTITY ()

57

57

Examples

57

57

21: SELECT

58

58

Examples

58

SELECT

58

WHERE

58

ORDER BY

58

GROUP BY

58

HAVING

59

N

59

OFFSET FETCH

59

FROM ( )

59

22: SQL Server Management Studio (SSMS)

61

61

Examples

61

IntelliSense

61

23: SQL Server

62

Examples

62

SQL Server 2016

62

XML SQL Server 2008/2012/2014

63

T-SQL XML

63

24: SQL Server JSON

64

64

64

64

Examples

64

FOR JSON JSON

64

JSON

64

CROSS APPLY OPENJSON JSON

65

JSON

66

FOR JSON JSON

67

OPENJSON JSON

67

25: SQL Server

68

Examples

68

STUFF

68

String_Agg

68

26: SQL Server

69

69

Examples

69

AS

69

=

69

69

AS

69

27: SQLCMD

71

71

Examples

71

SQLCMD.exe

71

28: SQLCMD txt

72

72

Examples

72

SQLCMD

72

29: STUFF

73

73

Examples

73

STUFF ()

73

FOR XML

73

( )

74

SQL

74

STUFF () .

74

30: TEMP

76

76

Examples

76

76

76

77

31: TRY / CATCH

78

78

Examples

78

TRY / CATCH

78

try-catch

78

try catch .

79

RAISERROR

79

TRY / CATCH

79

32: WHILE

81

81

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

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

Google Online Preview   Download