Building Basic SQL scripts

A-Z of Mircrosoft SQL

Main Page Introduction SSMS Acronym's used in SQL SQL Commands SQL Functions SQL Store Procedures SQL Views SQL Triggers SQL Operators SQL - Adding Comments SQL Alias SQL Joins SQL - Building Basic Scripts SQL - Execution Plan Questions or Suggestions
H1B Jobs- Visual Reports

SQL Examples

Arithmetic Operators Comparision Operators Logical Operators Bitwise Operators String Functions Date Functions Numeric Functions


Building Basic SQL scripts

This page has some random examples of how we using commands , filters based on situations or requriments. We are quiering only one table [AdventureWorks2012].[Person].[Address]

You can simple scroll through to get a idea of how developers usually think to build scripts

Quering data from a table

Select Statment SQL

Using Where clause on a certain Column Name

Where clause -SQL

Checking how many distinct addressid's are present in this table

Count function SQL

Chekcing for data where Addressline1 Field has the term 'Round' at any location

Like Operator SQL

Checking for data where Addressline2 Column has data

IS NULL Function SQL

Checking for records which were modified in year 2012

Year Function SQL

Using Order by , to order the records by Modifieddate Field

Order by SQL

Check for the address which were modified the latest among all

SubQuery SQL

SQL - Execution Plan