creating identity table & insert values

create table cricketers
(
    playerno int identity(100,2),
    playername  varchar(50),                             
    country char(15),
    point int,
    postion varchar(50)
)

insert into cricketers values('sachin tendulcar','india','876','batsman')
insert into cricketers values('jaques kallis','south africa',798,'all rounder')

creating a table & insert values

create  table employee

(
    ecode char(10),
    ename varchar(30),
    city char(20),
    salary money,
    age int
)

insert into employee values ('e001','manash','kolkata',26000,26)
insert into employee values ('e002','saikat','london',26000,26)
insert into employee values ('e003','plash','bengalore',26000,26)
insert into employee values ('e004','sundip','mumbai',26000,26)
insert into employee values ('e005','sudip','santipur',26000,26)
insert into employee values ('e006','babon','kolkata',26000,26)
insert into employee values ('e007','aniban','london',26000,26)
insert into employee values ('e008','souvik','kolkata',26000,26)

creating a database

create database student
on primary
(
    name='p_data',
    filename='d:\sql\p_data.mdf',
    size=10mb,
    maxsize=20mb,
    filegrowth=2mb
)

log on
(
    name='p2_log',
    filename='d:\sql\p2_log.ldf',
    size=12mb,
    maxsize=20mb,
    filegrowth=3mb
)

alter database  ss
add file
(
    name='ndf7_data',
    filename='d:\sql\s\ndf7_data.ldf',
    size=11mb,
    maxsize=21mb,
    filegrowth=3mb
),
(
    name='ndf6_data',
    filename='d:\sql\s\ndf6_data.ldf',
    size=11mb,
    maxsize=21mb,
    filegrowth=3mb
)
go

SQL Server improving

In the ten years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include: an ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP and data mining server , and several messaging technologies, specifically Service Broker and Notification Services.