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')