Category Archives: SQL

T-SQL Fundamentals Chapter 2

In Itzik Ben-Gan's book, Microsoft® SQL Server® 2008 T-SQL Fundamentals, Chapter 2 introduces the SELECT statement focusing on queries against a single table. This chapter describes logical query processing including the series of logical phrases involved in producing the correct result set of a given SELECT query. Elements of the SELECT Statement 1. The purpose…
Read more

T-SQL Fundamentals Chapter 1

In Itzik Ben-Gan's book, Microsoft® SQL Server® 2008 T-SQL Fundamentals, Chapter 1 teaches some good basics for understanding database architecture: 1. SQL Server can contain multiple databases. The setup program creates several system databases that hold system data serving internal purposes. After installation, you can create user databases that hold application data. (p. 14) 2.…
Read more

SQL – A Look Back

Recently, I was asked to share my SQL experience with an interested professional. Since it has almost been three years since this coursework, I struggled to remember the training received. I have been out of school now for over two years. My last SQL class was Spring term 2012. This class was an Advanced SQL…
Read more

SQL Question 22

Problem Use AP Create a stored procedure names uspBalanceRange that accepts 3 optional paramters. The procedure returns a result set consisting of VendorName, InvoiceNumber, and Balance for each invoice. The balance is calculated as InvoiceTotal - CreditTotal - PaymentTotal Parameters: @VendorVar, @BalanceMax, @BalanceMin If the procedure is called with no parameters or @BalanceMax is 0…
Read more