
Get started
Bring yourself up to speed with our introductory content.
SQL Transact SQL T SQL
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
Cursor related statements
This book excerpt illustrates cursor statements, including the open statement, fetch statement, @@fetch_status, close statement and the deallocate statement for T-SQL cursors.Continue Reading
Special data types-Part 1
In book excerpt, special data types are defined, including: timestamp, uniqueidentifier, and cursor and xml data types, a major new feature in SQL Server 2005. User defined data types are also explained, which can be defined in Transact-SQL or .NET.Continue Reading
Transact SQL cursors
T-SQL cursors are used to repeat custom processing for each row of the cursor. The following excerpt outlines how to process a cursor for Transact-SQL Server and gives an example.Continue Reading
Date, time and number data types in SQL Server
In this book excerpt on basic T-SQL programming constructs, date and time, integer numbers, approximate numbers, exact numbers, monetary and binary data types are defined and examples given.Continue Reading
Unconditional and scheduled execution
Unconditional execution (the GoTo Statement) in T-SQL forces the server to continue the execution from a label within a stored procedure or batch. Scheduled execution (the WaitFor Statement) allows the developer to schedule a time for the remaining ...Continue Reading
-
Character string data types
There are four different character data types that store character strings: char, varchar, varchar(max), and text. There are also four character data types for storing unicode data: nchar, nvarchar, nvarchar(max) and ntext. This book excerpt on ...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
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
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