Get started
Bring yourself up to speed with our introductory content.
SQL Transact SQL T SQL
An introduction to SQL Server 2016 dynamic data masking
An expert provides a step-by-step guide for how to use dynamic data masking in SQL Server 2016 CTP2 and Azure SQL database to protect sensitive data. Continue Reading
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT
In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
How to create a SQL inner join and outer join: Basics to get started
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Continue Reading
-
Top 10 SQL Server development questions
Development in SQL Server can put you in a crunch and seeking for a quick solution. We've compiled a Top 10 list of your frequently asked questions when it comes to SQL Server development. In this quick reference you'll get solutions to combat ... Continue Reading
FAQ: Creating and altering SQL Server tables
Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help. Continue Reading
FAQ: SQL Server stored procedure how-tos
Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.Continue Reading
Local variables
SQL Server 2005 recognizes only local and table variables. This book except outlines operations such as declaring variables, assigning values with the select, set, or update statement; and displaying values. Also find some workarounds for potential ...Continue Reading
Global variables
Your SQL Server maintains values in global variables. They carry information specific to the server or user session and can be examined from anywhere and return one value. Get more on this and how global variables begin with the @@ prefix and do not...Continue Reading
T-SQL identifiers
T-SQL Identifiers are used in all databases, servers and database objects in SQL Server. Identifiers are assigned to identify and object when it is created, but can be changed after. Rules and tips for creating identifiers are outlined in the ...Continue Reading
Table variables
Table variables are similar to temporary tables and are declared using the table data type. This following book excerpt contains further explanations and examples for declaring table variables when working T-SQL programming constructs.Continue Reading
-
Blocks, looping and conditional flow control statements
Statements blocks (Begin…End) can be used to group several statements to be executed together. Conditional execution (If statements) are used to change the flow of code based on the value of a condition. T-SQL contains only one statement that...Continue Reading
Flow control statements
T-SQL flow-control statements require skill and lack user friendliness, yet they allow for complex procedures. This book excerpt covers the use of comments. Comments can be included inside the source code of a batch or stored procedure. Comments ...Continue Reading
Database object qualifiers
The name of a database object has four identifiers. These identifiers must comply with the rules for T-SQL identifiers. This is referred to as the object's fully qualified name. The following excerpt outlines the different schemas that can be ...Continue Reading
Problems and justified use of cursors
The use of cursors in T-SQL should traditionally be avoided when possible, as they are a procedural feature and performace penalties tend to be a problem. However, this excerpt outlines situations in which cursors are acceptable, and even necessary.Continue Reading
Special data types-Part 2
This section continues discussion of special data types, including table and the cursor types and also traditional user-defined data types.Continue Reading