Translate

Thursday, 9 September 2021

 

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