Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the result of the below query: SELECT PATINDEX('%NET%', 'DOTNETFUNDA') AS 'Index'
on 9/26/2013 | Category:
Sql Server Interview questions
| Views: 1666 |
Select from following answers:
None of the above
PATINDEX() function returns the position of pattern-match string;
SELECT PATINDEX('%NET%', 'DOTNETFUNDA') AS 'Index' -- 4.
Here Pattern is matching thats why returning position of NET
SELECT PATINDEX('NET%', 'DOTNETFUNDA') AS 'Index' -- 0.
Here searches for string starting with NET and then one or more chars ( For example NETA, NET, "NETsdsadf", "NET 3253".... But out string starting with DOT.. So result is 0
SELECT PATINDEX('%NET', 'DOTNETFUNDA') AS 'Index' -- 0
Same as above
Show Correct Answer
Many Interviews |
< Previous :
Shared locks are not compatible with exclusive loc ...
Next > :
What is the result of the below query: SELECT SUBS ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What is the result of the below query: SELECT SUBSTRING('DOTNETFUN ...
By default, which type of index is created for a primary key?
Which of the following is true?
Which of the following are T-SQL ranking functions that can be used fo ...
Which of the following is correct about DELETE and TRUNCATE statements ...
Which of the following is true about Implicit Transactions?
Which of the following is NOT used for getting auto-incremented value ...
Which of the following are the metrics used to evaluate performance of ...
Latest Interview Questions
You have created an assembly that utilizes unmanaged code to access ex ...
You have an application that is used by international clients. All cli ...
Your application uses two threads, named threadOne and threadTwo. You ...
You need to create a method to clear a Queue named q.
You need to write a multicast delegate that accepts a DateTime argumen ...
Differentiate between a page theme and a global theme?
ASP .Net Page class, in which of them would you attach an event handle ...
What is right way to define the routes.MapRoute() method in MVC?