SQL SERVER 2005 Notes

SQL- Structured Query Language is an DataBase Management language(DBML).and sql server is an DBMS.

Mysql,oracle etc are name of different kind of DBMS..

database is a collection of tables;
and table is a collection of fields or columns.
further record is a collection of related columns value.


Database:

How to create data base:
Sql is case in-sensitive. so be happy buddy and enjoy your typing. keep in mind spelling is correct.:)...

Syntax is:

Create Database databaseName

then execute this: by press F5 or {!excute} button on tool bar.


Create database Mydatabase

after creating you have to Use this database.

Syntax for this is:

Use Database databasename

use database mydatabase
then (F5)