It will give records for 1st and 2nd queries but for 3rd query,it will generate error saying that
Msg 245, Level 16, State 1, Line 5
Conversion failed when converting the varchar value '1,2' to data type int.
1,2 will be treated as single string value and when passed in IN clause will give error as above.
Asked In: Many Interviews |