How to create Table,Insert,Update,Delete in SQL Server very easy steps
How to create Table,Insert,Update,Delete in SQL Server very easy steps
/*How to create Table,Insert,Update,Delete in SQL Server very easy steps*/
Create database Test1
USE Test1
Create table Student
(
Stu_id Nvarchar(20),
Stu_name Nvarchar(40),
stu_dept Nvarchar(40)
)
select * from Student
insert into Student(Stu_id,Stu_name,stu_dept)
values('T10001','kannan','CSE')
update Student set stu_dept='IT' Where
Stu_id = 'T10001'
delete from Student where Stu_id = 'T10001'