DECLARE @techonthenet VARCHAR(50); Value of the @techonthenet variable can be changed using the SET statement, as follows:
A. SET @techonthenet = ‘Example showing how to declare variable’;
B. SELECT @techonthenet = ‘Example showing how to declare variable’;
C. SET @techonthenet == ‘Example showing how to declare variable’;
D. None of the mentioned
Answer:A
DECLARE @techonthenet VARCHAR(50); Value of the @techonthenet variable can be changed using the SET statement, as follows:
A. SET @techonthenet = ‘Example showing how to declare variable’; B. SELECT @techonthenet = ‘Example showing how to declare variable’; C. SET @techonthenet == ‘Example showing how to declare variable’; D. None of the mentioned
Explanation:SET keyword sets the specified local variable, previously created by using the DECLARE.