Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
What is wrong with the T-SQL batch statement below:
@find varchar(30);
SET @find = 'Man';
SELECT LastName FROM Person WHERE LastName = @find;
You can't use the @find parameter in a query
DECLARE is missing
Nothing, it's fine
You should use SELECT instead of SET
That was the correct answer, well done!
Sorry, that was the wrong answer
Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2021
All rights reserved