I have been using SET keyword to assign the values to parameters declared in SQL Server something like,
Declare @StudentName Nvarchar(max) SET @StudentName='ABC'
I'm not sure how to write this if they are more than 1 student name.
Say student names are being fetched from another Select Statement (Select student_name from student_tbl)
Will that be
SET @StudentName= 'Select student_name from student_tbl'
I'm not sure how SET works in case of multiple values.