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... -
Welcome to beginner to advance T-SQL tutorial. In this tutorial I have explained you about basic to advance T-SQL statement .This tutorial ... -
create a table simple tableperson create table person ( p_id int, firstname varchar(50), lastname varchar(50), addr...
No comments:
Post a Comment