SQL Server Managment Studio

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


Basics of SSMS

SSMS= Sql Server Managment Studio

We use the Microsoft SSMS in order to connect to the databases and write queries, below are some pictures and option in SSMS

Here is a helpful source from SQL SERVER NET for step by step information to download SQL Server on your system .

Click Here

SSMS - All the options present with the application

Here is a screenshot of SSMS, the way we see it once running. Below are some quick options which we use on day to day basis.

SSMS will have lot of options , but we can start of with learning just a few most important - and we eventually catch on.

Once you have installed SSMS, you should be able to write some queries once connected to a DB SERVER.

Next Stop: Acronym's used in SQL