IOT Virtual Conference - Register now to book your ticket and get updates
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Bheema Vidyuth
1.5k
490
137.3k
Subquery returned more than 1 value This is not permitted ??
Jul 23 2020 6:56 AM
i am copying 2 column from a source table to target.
issue is when i selecting 2 column values and and trying to inserting to target table, i am getting below error.any idea?
Msg 512, Level 16, State 1, Line 27
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
INSERT INTO destinationtable(firstname,lastname,age,school)
SELECT
(SELECT sourcetable.firstname From sourcetable),
(SELECT sourcetable.lastname From sourcetable),19,UP school
Reply
Answers (
2
)
How to connect Sql Authentication Mode in SQL Server?
Why the error cannot login to the sa account while the sa account test