current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help

Microsoft SQL Server


103 Topics

22 requests active popular

Getting started with Microsoft SQL Server Introduction Topic

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

String Functions All Versions

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

Join All Versions

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

Retrieve Information about your Database All Versions

8
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 at 18:39
+6

Dates All Versions

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

Stored Procedures All Versions

10
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 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 Sep 4 at 3:32

NULLs All Versions

5
COALESCE ()
4
ANSI NULLS
3 more examples
0 improvement requests
0 proposed changes
edited Nov 23 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 at 23:50
+3

Aggregate Functions All Versions

3
AVG()
3
COUNT()
4 more examples
0 improvement requests
0 proposed changes
edited Nov 29 at 19:29
+1

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 at 19:11

MERGE All Versions

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

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 Nov 14 at 2:14
+3

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 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 at 14:07

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 Aug 8 at 7:22

CREATE VIEW All Versions

2
CREATE VIEW
2
CREATE VIEW With an Index
4 more examples
1 improvement request
0 proposed changes
edited Dec 3 at 16:21

FOR XML PATH SQL Server 2005–SQL Server 2016

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

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 at 21:55

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 at 19:18
+2
1 2 3 4 5 6

Introduction Topic

 Getting started with Microsoft SQL Server