Introduction

After data is in the database, it is inevitable that the data will need to be accessed, changed, and reported on. To perform these basic operations, you need to be able to apply the programming constructs of Structured Query Language (SQL) ” specifically , Microsoft's implementation referred to as Transact-SQL (T-SQL).

Understanding how to access and modify data is vital for any developer, beginner, or expert. This chapter discusses the not-so-tough topics of querying and modifying data, and then proceeds to the more advanced topics of data retrieval and modification.