Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You're designing a new SQL Server 2012 query for the HR department. The query will find records from the persons table for people whose name starts with 'Ja'. Which WHERE statement would be the correct choice?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 487 |
Select from following answers:
where (name = 'Ja%')
where (name like '%Ja%')
where (name > 'Ja')
where (name like 'Ja%')
LIKE keyword is used to search for partial string in a column
Show Correct Answer
Many Interviews |
< Previous :
You're designing a new query that will eventua ...
Next > :
If you use the BEGIN TRANSACTION statement, then e ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
If you use the BEGIN TRANSACTION statement, then execute 2 insert stat ...
What is missing from the T-SQL statement below for creating and using ...
The transaction isolation level controls the locking and row versionin ...
You're designing a new SQL Server 2012 table that will hold millio ...
As part of a new HR project you're creating several stored procedu ...
Which word is missing from the following statement to create a stored ...
You need to write a new query that will return names from the employee ...
You're designing a new query that will return all of the medical r ...
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 ...