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)
Subscribe to:
Post Comments (Atom)
sql server index
sql index An index is an internal table structure that sql server uses to provide quick access to rows of a table based on the values...
-
In the ten years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance... -
create database student on primary ( name = 'st_data' , - - à it is use for logical name. filename = 'f:\my... -
create a table simple tableperson create table person ( p_id int, firstname varchar(50), lastname varchar(50), addr...
No comments:
Post a Comment