Getting Started with the T-SQL

1. In order to start SQL server goto start button select Microsoft SQL Server Management studio from the sql software installed or type ssms and run command button.
   1. The management studio server is opened select the server type, server name (provide the same name that you have given during installation of sql) and click connect.
   1. Then create a database by right clicking on the database folder in the left side provide the name.
   2. Create the table by right clicking on the left side of the screen on tables. Provide all the field names and data types and save the table.
   3. Right click on the table and select option edit top 200 rows the structure of table is created.
   4. When the structure is created we can edit the details of the fields in the table. Likewise we can create many tables.

   Reply

2. Getting Started with SQL Server:
   SQL Server Installation:
   1.Go to start button select Microsoft SQL Server Management studio from the sql software installed or type ssms and run command button.
   2.The management studio server is opened select the server type, server name (provide the same name that you have given during installation of sql) and click connect.

   Create a database:
   1.Create a database by right clicking on the database folder in the left side provide the name.
   2.Create the table by right clicking on the left side of the screen on tables. Provide all the field names and data types and save the table.
   3.Right click on the table and select option edit top 200 rows the structure of table is created.
   4.When the structure is created we can edit the details of the fields in the table. Likewise we can create many tables.

   Reply

3. To start SQL server goto start button select Microsoft SQL Server Management studio or type ssms in the run command and MS SQL Server dialog box opens.
   Enter Server type, Server name and click ‘Connect’ and MS SQL Server database opens up.
   1.Then create a database by right clicking on the database folder in the left side.
   2.Create the table by right clicking on the left side of the screen on tables. Provide all the field names and data types and save the table.

   Reply

4. To get started with T-SQL :
   Goto Start button select Microsoft SQL Server Management studio from the sql software installed or type ssms and run command button. When the server is opened select the server type, server name (provide the same name that you have given during installation of sql) and click connect.
   1)Create a database by right clicking on the database folder in the left side.
   2)Create the table by right clicking on the left side of the screen on tables. Provide all the field names and data types and save the table.
   a)Right click on the table and select option edit top 200 rows the structure of table is created.
   b)When the structure is created we can edit the details of the fields in the table.

   Reply

5. To Get Started with T-SQL :
   – Go to start button select Microsoft SQL Server Management studio from the sql software installed or
   – Type ssms and run command button.
   – The management studio server is opened.
   – Select the server type, server name (provide the same name that you have given during installation of sql)
   – Click connect.

   To Create Database :
   – Right click on the database folder in the left side provide the name.
   – Create the table by right clicking on the left side of the screen on tables.
   – Provide all the field names and data types and SAVE the table.
   – Right click on the table and select option edit top 200 rows: “the structure” of table is created.
   – When the structure is created we can edit the details of the fields in the table. Likewise we can create many tables.

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.