Pages

Wednesday, September 30, 2015

How to use SQL Server Management Studio

Getting Started with SQL Server Management Studio :-

     SSMS(SQL Server Management Studio) is an integrated management, development, and querying application with many features for exploring and working with your databases. 
SSMS is based on the Visual Studio shell.

Monday, September 28, 2015

Working with SQL Server 2012 Object Explorer

Use of Object Explorer :-

Object Explorer is a graphical tool for managing SQL Server instances and databases. It is one of several SSMS window panes available from the View menu.Object Explorer provides direct interaction with most SQL Server data objects, such as tables, views, and procedures.

Right-clicking an object, such as a table,will display context-sensitive commands, including query-generators and script generators for object definitions.

Tuesday, September 15, 2015

Working with SQL Server 2012 Script files and Projects

 SQL Server 2012 Script files and Projects :-

SSMS allows you to create and save T-SQL code in text files, typically given a .sql file extension. Like other Windows applications that open, edit, and save files, SSMS provides access to file management through the File menu and through standard toolbar buttons.