Learn Sql server in hindi/urdu part-2 (Constraints ,not null ,unique, id...

create database sql1707b1



use sql1707b1







create table student

(



id int primary key identity,

name nvarchar(20) not null,

batchcode nvarchar(20) not null,

contactnumber nvarchar(20) not null unique



)









insert into student (name,batchcode,contactnumber)

values('safeer','1707b1','03425321680')





insert into student (name,batchcode,contactnumber)

values('naseer','1707b1','03415321680')







delete from student --deleting record..........

drop table student





select * from student





select * from student where id=1

Learn Sql server in hindi part-1 (create database,use database,create ta...

create database sql1707b1



use sql1707b1







create table student

(

id int,

name nvarchar(20),

batchcode nvarchar(20),

contactnumber nvarchar(20)



)



select * from student



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

values(1,'sahil','1707b1','03425321680')



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

values(2,'Hammad','1707b1','03424323680')



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

values(3,'AbuZar','1707b1','03413325581')