Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be the output of
Declare @str Varchar(1000) = 'http://www.dotnetfunda.com/articles/show/3158/import-xml-file-and-transform-into-relational-model-for-dynamic-column'
SELECT LEFT(SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)),PATINDEX('%[^0-9]%', SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)) + 'v')-1) ?
on 10/24/2015 | Category:
Sql Server Interview questions
| Views: 219 |
Select from following answers:
The PATINDEX('%[0-9]%'...) is searching for the integer pattern and the Substring function is used to extract and remove the unwanted characters.
Show Correct Answer
Many Interviews |
< Previous :
What will be the output of the below code segment? ...
Next > :
What will be the output of SQL> Select 2 ...
Comments or Responses
Login to post response
More Interview Questions by Rajnilari2015
What will be the output of SQL> Select 2 Compose('A' ...
What is true about Percentile_Cont function?
Suppose we have a set with 39 elements. We need to find the relative r ...
Suppose we have a set with 35 elements. We need to find the cumulative ...
What is the formula for Cume_Dist function?
What is Cume_Dist function?
What is the range of values return by Percent_Rank function?
What is the formula upon which the Percent_Rank function works?
Latest Interview Questions
Which of the following is a server-scoped securable?
The Clients table includes the following columns ClientId Spouse Ki ...
You would include a HAVING clause in a query to
How can you prevent user to enter duplicate value into column while cr ...
What is AngularJS?
What is the role of implementation phase in STLC(Software Testing Life ...
What is test plan ?
What is test planning?