Learn Sql server in hindi/urdu part-4 (Alter Table ,Update Table and Whi...

alter table student



add dateofadmission date





select * from student



update student

set dateofadmission='11/14/2016'

where id in (2,4)







Declare @Number int



Set @Number = 1008

While(@Number <= 1010)

Begin



 update student

set dateofadmission='11/11/2016'

where id =@Number





 Set @Number = @Number + 1





End







insert into student(name,batchcode,contactnumber,dateofadmission)

values('xyz','14b2v1','090078601',GETDATE())





select * from student

Learn Sql server in hindi/urdu part-4 (Not Operator and Order By Clause)

select * from student --display all data



select  id,name,contactnumber from student --display selected column



select * from student where batchcode='1208c1' -- where clause with one column



select * from student where name='emad' and batchcode='1708c1' and id=1003 --where clause with and operator



select * from student where batchcode='1708c1' or batchcode='120c1'



select * from student order by name  desc



select * from student order by name  asc



select * from student order by id desc



select * from student where batchcode!='1707b1' and batchcode!='1610c1'





select * from student where batchcode!='1707b1' or batchcode!='1610c1'





select * from student where batchcode not in ('1707b1','1610c1','1502c1')



select * from student where id not in (1002,1003,1004,2,4)