Exam 70-461 topic 2 question 6 discussion

Actual exam question from Microsoft's 70-461

Question #: 6
Topic #: 2

You use Microsoft SQL Server 2012 to develop a database application.
Your application sends data to an NVARCHAR(MAX) variable named @var.
You need to write a Transact-SQL statement that will find out the success of a cast to a decimal (36,9).
Which code segment should you use?

A. BEGIN TRY SELECT convert (decimal(36,9), @var) as Value, 'True' As BadCast END TRY BEGIN CATCH SELECT convert (decimal(36,9), @var) as Value, 'False' As BadCast END CATCH
B. TRY( SELECT convert (decimal(36,9), @var) SELECT 'True' As BadCast ) CATCH( SELECT 'False' As BadCast )
C. SELECT CASE WHEN convert (decimal(36,9), @var) IS NULL THEN 'True' ELSE 'False' END AS BadCast
D. SELECT IIF(TRY_PARSE(@var AS decimal(36,9)) IS NULL, 'True', 'False' )

Show Suggested Answer

Suggested Answer: D 🗳️
Reference: http://msdn.microsoft.com/en-us/library/hh213126.aspx

by lilupv at July 29, 2020, 7:20 a.m.

Comments

Submit Cancel

lilupv

4 years, 10 months ago

if the statement select TRY_PARSE(@var AS decimal(36,9)) returns value (converting was successful) than D returns False. Is it correct?

upvoted 1 times

...