|
|
|
Online course
E-learning-Transact-Sql
The query language that uses Microsoft SQL Server is a variant of the ANSI-standard Structured Query Language, SQL. The SQL Server variant is called Transact-SQL. Database developers and database administrators must have a thorough knowledge of Transact-SQL to read data from and write date to SQL Server databases. Using Transact SQL is the only way to work with the data.
|
Types of joins
CASE expression
PIVOT operators, Full Text Search function and the TABLESAMPLE clause
System Functions
User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause
Use of transactions
TRY and Catch Blocks
10 tips about SQL Server that every developer should know
|
1
0
