Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be the output of below query?
select try_parse('111' as int) as 'Number1',try_parse('222.000' as int) as 'Number2',try_parse(.abcD1234E.000' as int) as 'Number3';
on 11/28/2013 | Category:
Sql Server Interview questions
| Views: 2855 |
Select from following answers:
Answer will be 111,222,null. Because Try_Parse is introduced in Sql-Server 2012,which gives us exact output what we want.
In above query,it checks whether given expression is Number,Decimal Or Character. If given expression is a Number or Decimal,then it returns the same expression,if expression is a Character,then it returns NULL.
Show Correct Answer
Many Interviews |
< Previous :
What will be the output of below query? select ...
Next > :
What is the difference between Finalize and Dispos ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
What is the difference between Finalize and Dispose method in Dot Net?
How to create Table without using Create Statement?
What will happen,when we compile below C# function? private void ch ...
What will be the error,if we Compile below function in C# application? ...
What will happen,if we compile below code in C#? private int sum(in ...
Can we call Any Function or Method inside Finally Block?
Can we have Return Statement in Finally Block?
Can we have WHERE CLAUSE in SELF JOIN?
Latest Interview Questions
Which processes implemented sandbox solution?
Which of the following files/programs are not removed by the uninstall ...
What is compatibility level of SQL server 2012?
DBCC SHRINKDATABASE (UserDB, 10); What is the unit of second paramet ...
We can configure individuals to be alerted about sql server agent jobs ...
Which of the following built in tool allows you to changes services ac ...
Which of the following is FALSE regarding the tempdb database?
We can RECOMPILE a stored procedure in SQL server. Which of the follow ...