USE pubs
GO
DECLARE @firstname varchar(20)
SELECT @firstname = au_fname
FROM authors
WHERE au_lname = 'Greene'
SELECT @firstname -- Return the first name as a result
SELECT @firstname = au_fname
FROM authors
WHERE au_lname = 'Ben-Gan'
SELECT @firstname -- Return the first name as a result
GO
DECLARE @firstname varchar(20)
SELECT @firstname = au_fname
FROM authors
SELECT @firstname
GO
DECLARE @firstname varchar(20)
SELECT @firstname = (SELECT au_fname
FROM authors)
SELECT @firstname
GO
