 | SQL Server Basic Aggregation Functions
The twenty-seventh part of the SQL Server Programming Fundamentals tutorial describes the use of the aggregation functions that can be used when executing queries. These functions allow you to perform calculations based upon multiple result rows. |
| SQL Server Except and Intersect
The twenty-sixth part of the SQL Server Programming Fundamentals tutorial reviews two set operations that are available in SQL Server 2005 queries. Both EXCEPT and INTERSECT use a combination of two sets of results to determine the rows returned. |
| SQL Server Union Operations
The twenty-fifth part of the SQL Server Programming Fundamentals tutorial takes a step back from creating database schemas and procedures and returns to queries. In this article we consider the use of the UNION keyword in Transact-SQL. |
| SQL Server Check Constraints
The twenty-fourth part of the SQL Server Programming Fundamentals tutorial describes check constraints. These constraints add business rules to database tables to prevent invalid information being stored and damaging the domain integrity of the database. |
| SQL Server Stored Procedures
The twenty-third part of the SQL Server Programming Fundamentals tutorial describes stored procedures. A stored procedure allows you to create a script, or batch, containing multiple commands to be executed, potentially being controlled by parameters. |
| SQL Server Indexed Views
The twenty-second part of the SQL Server Programming Fundamentals tutorial describes indexed views. An indexed view is simply a view that has a unique clustered index and, optionally, one or more non-clustered indexes defined to improve query performance. |
| SQL Server Views
The twenty-first part of the SQL Server Programming Fundamentals tutorial examines the use of views. A view is a predefined SELECT statement that can be used as a virtual table, hiding complexities such as joins and filters from the consumers of the view. |
| Using Transactions in SQL Server
The twentieth part of the SQL Server Programming Fundamentals tutorial describes the use of transactions. Transactions allow you to execute several related T-SQL statements and ensure that the database remains consistent if one of the commands fails. |
| SQL Server Management Studio Start-Up Options
When you first start SQL Server Management Studio (SSMS), the default action for the program is to request the server, database and logon credentials before showing the Object Explorer. Depending upon your preferences, you may want to change this. |
| Transact-SQL Joins
The nineteenth part of the SQL Server Programming Fundamentals tutorial returns to the topic of querying. In this article, we examine joins using Transact-SQL (T-SQL). Joins allow data from several tables to be combined in a single set of results. |