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... -
create database student on primary ( name = 'st_data' , - - à it is use for logical name. filename = 'f:\my... -
Sql server database have three type of file 1) Primary data files 2) Secondary data files 3) log files What are primary data files? ...