Advertisement
yuvarajupadhyaya

assign parameter with select

Jun 9th, 2022
4,379
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. DECLARE @studentId nvarchar(15),@firstName nvarchar(MAX)
  2.     SELECT @studentId=studentId,@firstName=FirstName FROM student WHERE studentId='20100005'
  3.     SELECT @studentId AS 'StudentId',@firstName AS 'FirstName'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement