SQL Cheat Sheet, Cover all Basic SQL Syntaxes, Quick Reference Guide by Examples

About This Book
This book covers all basic SQL syntaxes, it contains about 300 examples, 300 outputs and 300 explanations. We can quickly reference the most helpful programming syntaxes, such as common command syntax, various function syntax, query statement syntax, database command syntax, datatable command syntax……; all these syntaxes are very useful for database administration.
We can take this book as a syntax dictionary because its entries are arranged alphabetically so that we can easily reference the important syntax.
Nowadays or in the future, the SQL Syntax Book can provide great help for coding both in our study and our work.


Table of Contents (from a to z)
@variable syntax:
@@connections syntax:
@@cpu_busy syntax:
@@datefirst syntax:
@@dbts syntax:
@@idle syntax:
@@io_busy syntax:
@@langid syntax:
@@language syntax:
@@lock_timeout syntax:
@@max_connections syntax:
@@max_precision syntax:
@@nextlevel syntax:
@@options syntax:
@@packet_errors syntax:
@@pack_received syntax:
@@pack_sent syntax:
@@procid syntax:
@@remserver syntax:
@@servername syntax:
@@servicename syntax:
@@spid syntax:
@@textsize syntax:
@@timeticks syntax:
@@total_errors syntax:
@@total_read syntax:
@@total_write syntax:
@@version syntax:
abs() syntax:
acos() syntax:
add syntax:
add constraint syntax:
all syntax:
alter column syntax:
alter table syntax:
alter view syntax:
and syntax:
any syntax:
app_name() syntax:
as syntax:
asc syntax:
ascii() syntax:
asin() syntax:
atan() syntax:
atn2() syntax:
avg() syntax:
backup database syntax:
begin… end syntax:
between syntax:
bigint type syntax:
binary() type syntax:
bit type syntax:
case syntax:
cast() syntax:
ceiling() syntax:
certprivatekey() syntax:
char() syntax:
char() type syntax:
charindex() syntax:
check syntax:
choose() syntax:
coalesce() syntax:
col_length() syntax:
col_name() syntax:
columnproperty() syntax:
concat() syntax:
concat_ws() syntax:
convert() syntax:
count() syntax:
cos() syntax:
cot() syntax:
create database syntax:
create index syntax:
create procedure syntax:
create table syntax:
create unique index syntax:
create view syntax:
current_timestamp syntax:
current_user syntax:
cursor syntax:
cursor_status() syntax:
database_principal_id() syntax:
databasepropertyex() syntax:
datalength() syntax:
date type syntax:
dateadd() syntax:
date_backet() syntax:
datediff() syntax:
datediff_big() syntax:
datefromparts() syntax:
datename() syntax:
datepart() syntax:
datetime type syntax:
datetime2 type syntax:
datetimefromparts() syntax:
datetime2fromparts() syntax:
datetimeoffset type syntax:
datetrunc() syntax:
……
……
……
xml type syntax:
year() syntax:

Appendix
SQL Server Keywords
String Data Types
Numeric Data Types
Date & Time Data Type
Other Data Type
Session Setting Chart
SQL Syntax Chart

Note:
The paperback version of this book is displayed in the lower part of this page.