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 11/24/2013 | Category:
Sql Server Interview questions
| Views: 4568 |
Select from following answers:
DECLARE is missing
Nothing, it's fine
You can't use the @find parameter in a query
You should use SELECT instead of SET
DECLARE keyword is missing before @find variable
Show Correct Answer
Many Interviews |
< Previous :
Which of the following is an example of a scalar s ...
Next > :
A Customers table has columns names as firstname a ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
A Customers table has columns names as firstname and lastname. Which o ...
Which of the following is FALSE regarding PRIMARY KEYS in SQL Server 2 ...
How to enforce rules for the type of information that can be stored in ...
Which of the following transaction isolation levels is the default in ...
Which of the following is FALSE regarding DML triggers?
If you have ON DELETE CASCADE statement to the foreign key relationshi ...
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'study'), ...
How to limit the results to include only the top 100 most recent recor ...
Latest Interview Questions
Which statement is False about Optional parameters in VB.Net?
How to get Row Index in MySQL?
How to get Table row no/row index in sql-server.
In case we are returning anonymous type from Controller to the views, ...
How many ways to compare String values in Dot Net?
In Gridview' RowEditing event, what piece of code should be writte ...
In Gridview' RowCancelingEdit event, what piece of code should be ...