ADVANCE DATABASE SYSTEM
01 ACTIVITY 1
INSTRUCTIONS:
Write T-SQL statements that will:
a. Declare a variable named LastName.
b. Set the value of the variable according to your last name.
c. Print/display the value of variable.
ANSWER:
DECLARE @LastName VARCHAR(50);
SET @LastName = 'REYES';
PRINT 'Last Name: ' + @LastName;
01 ACTIVITY 1
INSTRUCTIONS:
Write T-SQL statements that will:
a. Declare a variable named LastName.
b. Set the value of the variable according to your last name.
c. Print/display the value of variable.
ANSWER:
DECLARE @LastName VARCHAR(50);
SET @LastName = 'REYES';
PRINT 'Last Name: ' + @LastName;
