SQL Server / T-SQL examples (example source code) Organized by topic

SQL Server / T-SQL

Select Query /

ALL 1 AND 1

ANY 1 AS 3

Between AND 5 Bitwise Operator 1

Case 9 Column Alias 4

Compare Date 2 Data Type 1

Date Calculation 1 Date Compare 1

DESC 1 DISTINCT 3

EXISTS 5 Group BY 9

HAVING 6 IN 6

IS NULL 2 ISNULL 6

LIKE 10 Logical Operator 7

Math Operator 2 MAXRECURSION 1

NOT 4 NULL 3

Operator Precedence 2 OR 2

Order Columns 5 Order 11

Query Batch 1 Query Columns 6

Quotation Mark 1 Select Into 3

Select 13 String Compare 1

Top percent 4 Top With Ties 1

Top 7 Where 9

With 2

Subquery /

Correlated subquery 6 Nested Subquery 2

RTRIM 4 Subqueries ALL 1

Subqueries ANY 2 Subqueries Exists 4

Subqueries IN 5 Subqueries 4

Subquery Aggregate Functions 2 Subquery From 1

Insert Delete Update /

Batch Insert 2 BULK INSERT 1

Delete 6 Insert Image 1

Insert Select 4 Insert 5

Update 15

Data Set /

EXCEPT 1 INTERSECT 1

UNION ALL 1 Union 3

Store Procedure Function /

Create Function 5 Create Procedure 13

Default Parameter 3 Drop Procedure 1

EXEC 6 EXECUTE 2

Function Call 2 Function Parameters 1

Function Return 7 Procedure Call 3

Procedure Parameters 2 Recursive function 1

Scalar Functions 1

Transact SQL /

Assign Value 4 ATAN 1

Break 2 COALESCE 1

Code Block 2 Continue 2

Declare Variables 5 Delete Data 1

Dynamic SQL 4 Error 4

GOTO 1 Handle Error 1

If 7 Insert Data 6

LOG 2 Object Property 1

Print 1 Query Data 2

RAISERROR 2 Return 2

RowCount 3 schemas 1

Select Data 1 Select Variables 2

Set Variables 4 Statement 1

Table Variable 5 Update Data 5

Variable Scope 2 Variables 1

Version 1 WAITFOR 2

While 5

Trigger /

Alter Trigger 1 Create Trigger 3

Disable Trigger 1 Enable Disable Trigger 1

inserted table 1 INSTEAD OF Trigger 3

Trigger after 2 Trigger for Insert 1

Trigger for update 4 Trigger Value 2

UPDATE function 1

Table /

Add Column 3 Alter Table 2

Column Data Type 1 Column Index 1

Computed Column 2 Copy Data 1

Create Table 1 Derived Columns 1

Drop Column 2 Drop Table 3

Rename Column 1 Rename Table 1

Sub query 2 Table Alias 1

Table Copy 1 Table Existence 1

Table Properties 1 Temporary Table 3

TRUNCATE TABLE 2

Table Joins /

ANSI Join Syntax 3 Cross Join 3

INNER JOIN 4 Left Join 2

LEFT OUTER JOIN 1 RIGHT JOIN 1

RIGHT OUTER JOIN 2 Self Join 1

SQL Server Join Syntax 2 Table Join 10

View /

Alter View 2 Create View 13

Drop View 2 ENCRYPTION 1

Filter view 2 Inline view 2

Nested View 1 Query View 1

SCHEMABINDING 1 Updatable View 2

View Existance 1

Index /

CLUSTERED INDEX 2 Create Index 6

Drop Index 1 DROP_EXISTING 1

Database /

Create Database 3 Database Info 1

Database Option 7 databases 2

DROP DATABASE 2 USE 1

Transaction /

Commit Transaction 3 Transaction Roll back 4

Cursor /

Declare CURSOR 3 Fetch Data 2

Fetch_Status 1 Open cursor 2

Constraints /

Add Primary Key 2 CASCADE 1

Check Options 6 Check value range 3

Column Constraints 5 Constraints Basics 2

CREATE RULE 1 Default Value 3

Disable constraint 1 Foreign Key 4

Maintain Constaints 1 Nullable 3

Primary key 3 Unique 3

UniqueIdentifier 1

Sequence /

IDENTITY 12 IDENTITYCOL 1

IDENT_CURRENT 2 NEWID 1

Procedure Call 3 Procedure Existance 1

Procedure Permission 1 Procedure with Parameters 13

Data Type /

Bit 2 Cast 21

char 1 Convert 8

Data Type Convert 1 datetime 1

decimal 7 float 1

int 3 Money 1

nchar Data Type 1 Number Format 2

text 1 varchar 3

XML /

Date Timezone /

CURRENT_TIMESTAMP 1 Date Data Type 2

Date Format 12 DATEADD 18

DATEDIFF 19 DATENAME 14

DATEPART 13 Datetime 3

Day 4 GetDate 4

GETUTCDATE 2 Int 1

ISDATE 6 Month 4

Year 4

Aggregate Functions /

Aggregate Function Basics 2 AVG 4

Count 6 COUNT_BIG 2

MAX 3 MIN 2

SUM 2

Analytical Functions /

COMPUTE 5 Cube 2

DENSE RANK 2 NTile 1

Over 1 RANK 2

Row Number 3 STDEV 4

VAR 3 VARP 2

WITH ROLLUP 2

Math Functions /

ABS 2 ACOS 2

ASIN 1 CEILING 3

COS 2 COT 1

DEGREES 2 EXP 1

FLOOR 3 ISNUMERIC 3

Log10 2 mod 1

PI 1 Power 2

RADIANS 1 RAND 1

ROUND 9 SIGN 1

SIN 1 SQRT 1

SQUARE 1 TAN 1

String Functions /

ASCII 2 CHAR 3

CHARINDEX 5 COLLATE 1

DATALENGTH 3 Difference 4

Escape 1 LEFT 4

LEN 4 Lower 2

LTRIM 2 NCHAR 2

PATINDEX 2 QUOTENAME 1

Regular Expressions 5 REPLACE 3

REPLICATE 4 REVERSE 2

RIGHT 4 SOUNDEX 2

Space 2 STR 6

STUFF 2 Substring 4

UNICODE 1 UPPER 3

System /

columns 2 DATABASEPROPERTYEX 1

DB_ID 1 Error_Message 1

HOST_NAME 1 INFORMATION_SCHEMA 3

LOCK_TIMEOUT 1 LOGIN 1

OBJECT_ID 1 QUOTED_IDENTIFIER 2

Row Count 2 ROWCOUNT 1

SHOWPLAN_TEXT 2 sp_addmessage 2

sp_altermessage 1 sp_dboption 1

sp_dropmessage 1 sp_helpconstraint 1

sp_helpindex 1 sp_helptext 1

sp_unbindefault 1 STATISTICS 1

SUSER_SNAME 1 sys.sql_modules 1

sys.syscacheobjects 1 sys.types 1

sys.views 1 sys.XML_schema_collections 1

syscomments 1 sysdepends 1

sysmessages 2 sysobjects 2

sysusers 1 TOTAL_ERRORS 1

TOTAL_READ 1 USER 1

USER_NAME 1 views 1