Select from following answers:- 1,1,0
- 111,222,null
- True,False,True
- 111,222,abcd1234e
- All Above
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
Asked In: Many Interviews |
Alert Moderator