Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is wrong with the T-SQL batch statement below:
SET @find = 'Man';
SELECT LastName FROM Person WHERE LastName = @find;
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 439 |
Select from following answers:
You can't use the @find parameter in a query
DECLARE is missing
Nothing, it's fine
You should use SELECT instead of SET
Before accessing a variable in SQL Server, we must declare it by using DECLARE keyword
Show Correct Answer
Many Interviews |
< Previous :
You're designing a new query that will return ...
Next > :
SQL Server 2012 uses the standard four-part naming ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
SQL Server 2012 uses the standard four-part naming convention when ref ...
You're creating a new query that will select rows from a products ...
You need to delete a stored procedure from the SQL Server 2012 databas ...
Your manager has asked you to check the index stats for a particular t ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which of the following generates control-breaks and subtotals in the r ...
You've created a simple select statement that returns the customer ...
Your manager has asked you to design a new table and enforce rules for ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...