It is very important to have good knowledge and experience with SQL. SQL is short for Structured Query Language, and it is commonly used to handle and manage database records. Microsoft SQL Server has its own type of SQL called T-SQL or Transact-SQL. In this chapter we are going to use SQL Management Studio, which is installed along with Microsoft SQL Server.
The main commands of this language are Select
, Update
, Delete
, and Insert
.
This command is used to query records from the database.
The syntax used is as follows:
Select field1, field2 from table Select field1, field2 from view
We use the filtered views as follows:
Select name, address1_stateorprovince from FilteredAccount
Tip
Downloading the example code
You can download the example code files for all Packt Publishing books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to...