create table cricketers
(
playerno int identity(100,2),
playername varchar(50),
country char(15),
point int,
postion varchar(50)
)
insert into cricketers values('sachin tendulcar','india','876','batsman')
insert into cricketers values('jaques kallis','south africa',798,'all rounder')
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