MS SQL Inserting multiple rows in a single SQL query? [duplicate]
create table Utkarsh_Subject
(
SubjectId int primary key
,SubjectName varchar(20)
)
insert into Utkarsh_Subject(SubjectId,SubjectName)
VALUES(1,'SCIENCE'),(2,'MATHEMATICS'),(3,'ODIA'),(4,'ENGLISH')
check the values comes or not
select * from Utkarsh_Subject
No comments:
Post a Comment