SQL Server

A database management system (DBMS) by Microsoft Corporation.

All terms

«SQL Server» is also found here:

CHAR and VARCHAR. [3]

Bibliography. [3]

About generation of number sequences in SQL Server. [2]

Three-valued logic and WHERE clause. [2]

DATEDIFF function. [2]

CONCAT function. [2]

About implicit conversion of SQL Server data types. [2]

Truncate table statement. [2]

Adding rows to a table with identity column. [2]

The modify() Method. [2]

Integer division. [2]

Database «Recycled materials company». [2]

Exercise #3 (computer firm). [2]

CHAR and VARCHAR. [2]

Subqueries in Check Constraints. [2]

EOMONTH function. [2]

LEN() function, trailing spaces and uniqueness. [1]

Adding rows to a table with single identity column. [1]

Delimited identifiers. [1]

Window functions. [1]

Float(n). [1]

Aggregate function to aggregate function. [1]

Aggregate function to aggregate function. [1]

CROSS APPLY operator. [1]

Default values. [1]

LOG and EXP functions. [1]

CTE. Duplicates deleting in PostgreSQL. [1]

EXCEPT and duplicates elimination. [1]

Product of column values. [1]

Equivalents for analytic functions. [1]

DATEFROMPARTS function. [1]

NTILE function. [1]

LAG and LEAD functions. [1]

Number sequences in PostgreSQL. [1]

Paging records in SQL Server 2012. [1]

XML Data Type Methods. [1]

Database «Airport». [1]

IIF functions. [1]

Useful tips on how to work with the textbook . [1]

Terminology used and realization features. [1]

Exercise #7 (computer firm). [1]

Exercise #60 (recycling firm). [1]

Exercise #19 (ships). [1]

Exercise #53 (Ships). [1]

LEN function. [1]

Random sampling of rows from a table in SQL Server. [1]

Random sampling of rows from a table in SQL Server. [1]

Correlated subqueries. [1]

Intersect and Except. [1]

Data type conversion and CAST function. [1]

LIKE predicate. [1]

Ranking functions. [1]

RANK() and DENSE_RANK() functions. [1]

RIGHT function. [1]

DATEDIFF function. [1]

Exercise 54 (Ships). [1]

Exercise #56 (ships). [1]

Exercise #6 (tips and solutions). [1]

Exercise #8 (tips and solutions). [1]

Exercise #10 (tips and solutions). [1]

Exercise #15 (tips and solutions). [1]

Exercise #43 (tips and solutions). [1]

Exercise #(-2) (tips and solutions). [1]

Exercise #53 (tips and solutions). [1]

Exercise #59 (tips and solutions). [1]

Data manipulation language (DML). [1]

Data type conversion and CAST function. [1]

INSERT statement. [1]

Transact-SQL functions handling datetime data types. [1]

PIVOT and UNPIVOT Operators. [1]