What is wrong with the T-SQL batch statement below:

@find varchar(30);
SET @find = 'Man';
SELECT LastName FROM Person WHERE LastName = @find;

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 460 | Points: 40
Select from following answers:
  1. You can't use the @find parameter in a query
  2. DECLARE is missing
  3. Nothing, it's fine
  4. You should use SELECT instead of SET
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response