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
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
Downloading the example code
You can download the example ...