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...
-
create a table simple tableperson create table person ( p_id int, firstname varchar(50), lastname varchar(50), addr...
-
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... -
Create table The create table key word is used to crate a table in sql server database . Sql server create table syntax CREATE TAB...