Output:
Msg 10709, Level 16, State 1, Server 4604a73dfe25, Line 4 The number of columns for each row in a table value constructor must be the same. (7 rows affected) StudentId FirstName LastName Age DOB Email Mobile DepartmentId ----------- -------------------------------------------------- -------------------------------------------------- ----------- ---------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ------------ (0 rows affected) DepartmentId DepartmentName ------------ ---------------------------------------------------------------------------------------------------- 1 IT 2 CSE 3 ECE 4 EEE 5 MECH 6 BIO-MEDICAL 7 AGRICUTURE (7 rows affected)