current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help

Microsoft SQL Server


104 Topics

21 requests active popular

Getting started with Microsoft SQL Server Introduction Topic

32
Basic DML Operations in MS SQL Server
10
SELECT all rows and columns from a table
11 more examples
0 improvement requests
0 proposed changes
edited Nov 28 '16 at 16:46
+4

String Functions All Versions

10
Quotename
7
Replace
24 more examples
0 improvement requests
0 proposed changes
edited Nov 24 '16 at 9:32
+10

Join All Versions

16
Inner Join
12
Outer Join
6 more examples
0 improvement requests
0 proposed changes
edited Nov 29 '16 at 22:07
+16

Retrieve Information about your Database All Versions

9
Retrieve a List of all Stored Procedures
7
Get the list of all databases on a server
12 more examples
0 improvement requests
0 proposed changes
edited Nov 15 '16 at 18:39
+6

Dates All Versions

9
Date & Time Formatting using CONVERT
8
Date & Time Formatting using FORMAT
10 more examples
0 improvement requests
0 proposed changes
edited Oct 19 '16 at 17:40
+9

Stored Procedures All Versions

11
Creating and executing a basic stored procedure
6
Stored Procedure with If...Else and Insert Into operation
4 more examples
0 improvement requests
0 proposed changes
edited Sep 29 '16 at 20:38
+3

Index All Versions

3
Create Clustered index
3
Create Non-Clustered index
8 more examples
0 improvement requests
0 proposed changes
edited Dec 20 '16 at 19:47
+1

NULLs All Versions

5
COALESCE ()
4
ANSI NULLS
3 more examples
0 improvement requests
0 proposed changes
edited Nov 23 '16 at 0:26

INSERT INTO All Versions

7
INSERT multiple rows of data
4
INSERT a single row of data
4 more examples
0 improvement requests
0 proposed changes
edited Sep 11 '16 at 23:50
+3

Aggregate Functions All Versions

3
AVG()
3
COUNT()
4 more examples
0 improvement requests
0 proposed changes
edited 4 hours ago
+1

MERGE All Versions

6
MERGE to Insert / Update / Delete
4
Merge Using CTE Source
3 more examples
0 improvement requests
0 proposed changes
edited Sep 4 '16 at 3:10

CREATE VIEW All Versions

6
CREATE VIEW With an Index
4
CREATE VIEW
4 more examples
1 improvement request
0 proposed changes
edited Dec 23 '16 at 16:29

Temporal Tables SQL Server 2016

4
CREATE Temporal Tables
2
Creating a Memory-Optimized System-Versioned
6 more examples
0 improvement requests
0 proposed changes
edited Sep 29 '16 at 19:11

OVER Clause SQL Server 2005–SQL Server 2016

6
Cumulative Sum
4
Using Aggregation functions with OVER
2 more examples
0 improvement requests
0 proposed changes
edited 2 days ago
+4

In-Memory OLTP (Hekaton) SQL Server 2014–SQL Server 2016

4
Declare Memory-Optimized Table Variables
3
Create Memory Optimized Table
3 more examples
0 improvement requests
0 proposed changes
edited Oct 1 '16 at 0:02

Advanced options All Versions

2
Enable and show advanced options
2
Enable backup compression default
5 more examples
0 improvement requests
0 proposed changes
created Aug 4 '16 at 14:07

FOR XML PATH SQL Server 2005–SQL Server 2016

5
Using FOR XML PATH to concatenate values
2
Specifying namespaces
2 more examples
0 improvement requests
0 proposed changes
edited Jul 27 '16 at 17:32

User Defined Table Types SQL Server 2008–SQL Server 2016

2
Creating a UDT with a primary key and a column with a default value:
2
creating a UDT with a single int column that is also a primary key
2 more examples
0 improvement requests
0 proposed changes
edited Dec 17 '16 at 13:54

Common Table Expressions SQL Server 2005–SQL Server 2016

3
Generate a table of dates using CTE
2
Delete duplicate rows using CTE
4 more examples
0 improvement requests
0 proposed changes
edited Sep 18 '16 at 19:18
+2

The STUFF Function SQL Server 2005–SQL Server 2016

4
Using FOR XML to Concatenate Values from Multiple Rows
3
Basic Character Replacement with STUFF()
2 more examples
0 improvement requests
0 proposed changes
edited Sep 28 '16 at 21:55
1 2 3 4 5 6
Blog
Say Farewell to Winter Bash 2016!

Introduction Topic

 Getting started with Microsoft SQL Server