--Sql Server 2014 Express Edition

--Batches are separated by 'go'

​

select @@version as 'sql server version'

​

--Sql Server 2014 Express Edition

--Batches are separated by 'go'

​

select @@version as 'sql server version'

​

create table std1

( id int ,

name varchar(50),

address varchar(50),

age int);

​

insert into std1

values ( 1,'mohammed','skaka',34);

insert into std1

values ( 2,'khlid','somatrah',30);

insert into std1

values ( 10,'basem','skaka',20);

insert into std1

values (30,'jamal','skaka',99);

insert into std1

values (19,'saleh','skaka',34);

insert into std1

values ( 22,'talal','skaka',34);

​

select * from std1;

​

create index std_index

on std1(id);