Microsoft SQL Server Notes for Professionals

by Stack Overflow Community

DescriptionTable of ContentsDetailsHashtagsReport an issue

Book Description

The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow.

This open book is licensed under a Creative Commons License (CC BY-SA). You can download Microsoft SQL Server Notes for Professionals ebook for free in PDF format (2.7 MB).

Table of Contents

Chapter 1
Getting started with Microsoft SQL Server
Chapter 2
Data Types
Chapter 3
Converting data types
Chapter 4
User Defined Table Types
Chapter 5
SELECT statement
Chapter 6
Alias Names in SQL Server
Chapter 7
NULLs
Chapter 8
Variables
Chapter 9
Dates
Chapter 10
Generating a range of dates
Chapter 11
Database Snapshots
Chapter 12
COALESCE
Chapter 13
IF...ELSE
Chapter 14
CASE Statement
Chapter 15
INSERT INTO
Chapter 16
MERGE
Chapter 17
CREATE VIEW
Chapter 18
Views
Chapter 19
UNION
Chapter 20
TRY/CATCH
Chapter 21
WHILE loop
Chapter 22
OVER Clause
Chapter 23
GROUP BY
Chapter 24
ORDER BY
Chapter 25
The STUFF Function
Chapter 26
JSON in SQL Server
Chapter 27
OPENJSON
Chapter 28
FOR JSON
Chapter 29
Queries with JSON data
Chapter 30
Storing JSON in SQL tables
Chapter 31
Modify JSON text
Chapter 32
FOR XML PATH
Chapter 33
Join
Chapter 34
cross apply
Chapter 35
Computed Columns
Chapter 36
Common Table Expressions
Chapter 37
Move and copy data around tables
Chapter 38
Limit Result Set
Chapter 39
Retrieve Information about your Instance
Chapter 40
With Ties Option
Chapter 41
String Functions
Chapter 42
Logical Functions
Chapter 43
Aggregate Functions
Chapter 44
String Aggregate functions in SQL Server
Chapter 45
Ranking Functions
Chapter 46
Window functions
Chapter 47
PIVOT / UNPIVOT
Chapter 48
Dynamic SQL Pivot
Chapter 49
Partitioning
Chapter 50
Stored Procedures
Chapter 51
Retrieve information about the database
Chapter 52
Split String function in SQL Server
Chapter 53
Insert
Chapter 54
Primary Keys
Chapter 55
Foreign Keys
Chapter 56
Last Inserted Identity
Chapter 57
SCOPE_IDENTITY()
Chapter 58
Sequences
Chapter 59
Index
Chapter 60
Full-Text Indexing
Chapter 61
Trigger
Chapter 62
Cursors
Chapter 63
Transaction isolation levels
Chapter 64
Advanced options
Chapter 65
Migration
Chapter 66
Table Valued Parameters
Chapter 67
DBMAIL
Chapter 68
In-Memory OLTP (Hekaton)
Chapter 69
Temporal Tables
Chapter 70
Use of TEMP Table
Chapter 71
Scheduled Task or Job
Chapter 72
Isolation levels and locking
Chapter 73
Sorting/ordering rows
Chapter 74
Privileges or Permissions
Chapter 75
SQLCMD
Chapter 76
Resource Governor
Chapter 77
File Group
Chapter 78
Basic DDL Operations in MS SQL Server
Chapter 79
Subqueries
Chapter 80
Pagination
Chapter 81
CLUSTERED COLUMNSTORE
Chapter 82
Parsename
Chapter 83
Installing SQL Server on Windows
Chapter 84
Analyzing a Query
Chapter 85
Query Hints
Chapter 86
Query Store
Chapter 87
Querying results by page
Chapter 88
Schemas
Chapter 89
Backup and Restore Database
Chapter 90
Transaction handling
Chapter 91
Natively compiled modules (Hekaton)
Chapter 92
Spatial Data
Chapter 93
Dynamic SQL
Chapter 94
Dynamic data masking
Chapter 95
Export data in txt file by using SQLCMD
Chapter 96
Common Language Runtime Integration
Chapter 97
Delimiting special characters and reserved words
Chapter 98
DBCC
Chapter 99
BULK Import
Chapter 100
Service broker
Chapter 101
Permissions and Security
Chapter 102
Database permissions
Chapter 103
Row-level security
Chapter 104
Encryption
Chapter 105
PHANTOM read
Chapter 106
Filestream
Chapter 107
bcp (bulk copy program) Utility
Chapter 108
SQL Server Evolution through diffferent versions (2000 - 2016)
Chapter 109
SQL Server Management Studio (SSMS)
Chapter 110
Managing Azure SQL Database
Chapter 111
System database - TempDb
Appendix A
Microsoft SQL Server Management Studio Shortcut Keys
 

Book Details

Subject
Computer Science
Publisher
GoalKicker
Published
2018
Pages
285
Edition
1
Language
English
PDF Size
2.7 MB
License
CC BY-SA

Related Books

Data Science with Microsoft SQL Server 2016
R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic capab...
Python Notes for Professionals
The Python Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
SQL Notes for Professionals
The SQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
MySQL Notes for Professionals
The MySQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
PHP Notes for Professionals
The PHP Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
C# Notes for Professionals
The C# Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....