Wednesday, July 6, 2011
Wednesday, June 29, 2011
Transact-SQL using for SQL Server
create a table simple tableperson
create table person
(
p_id int,
firstname varchar(50),
lastname varchar(50),
address varchar(70),
city char(20)
)
select * from person
insert into person values (1,'saikat','ghosh','india','kolkata')
insert into person values (2,'ayon','dash','india','kolkata')
insert into person values (3,'anupom','saha','india','dunlop')
insert into person values (4,'saikat','dash','india','belghoria')
insert into person values (5,'saikat','ghosh','india','kolkata')
create table person
(
p_id int,
firstname varchar(50),
lastname varchar(50),
address varchar(70),
city char(20)
)
select * from person
insert into person values (1,'saikat','ghosh','india','kolkata')
insert into person values (2,'ayon','dash','india','kolkata')
insert into person values (3,'anupom','saha','india','dunlop')
insert into person values (4,'saikat','dash','india','belghoria')
insert into person values (5,'saikat','ghosh','india','kolkata')
Subscribe to:
Posts (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...