O'Reilly logo

Microsoft Dynamics CRM 2011 Reporting by Damian Sinay

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL overview

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.

Select

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required