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 11/24/2013 | Category: Sql Server Interview questions | Views: 6337 | Points: 40
Select from following answers:
  1. DECLARE is missing
  2. Nothing, it's fine
  3. You can't use the @find parameter in a query
  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