Tuesday, 20 May 2014

Chapter 1

HOW TO CREATE DATABASE

First Procedure

Run SQL SERVER as in administration





Second Procedure


Run  SQL SERVER as in administration , than follow the procedure in the following image


Execute it  by pressing F5


HOW TO CREATE TABLE IN DATABASE





Click on NEW TABLE



Enter the desired detail and then save it




You have created the Table


HOW TO CREATE TABLE


  • Rt click on Dbo.Employee
  • Open table
  • Now fill the required detail






HOW TO RETRIEVE ATTRIBUTE FROM DATABASE





HOW TO SELECT SPECIFIC COLOUM NAME IN THE "SELECT" STATEMENT








CUSTOMIZING THE DISPLAY











No comments:

Post a Comment