A collection of 19 FAQs on SQL Server Transact-SQL stored procedures. Clear answers are provided with tutorial exercises on creating and dropping stored procedures; retrieving and modifying stored procedures; ending stored procedures properly; defining and passing values through input and output parameters; temporary and permanent stored procedures.
A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.
A collection of 16 FAQs on creating and managing databases on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting databases; setting current database; bringing databases offline and online; reviewing, moving and copy database physical files.