More TRY_CONVERTing numbers

Question

Post reply

More TRY_CONVERTing numbers

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

Alan.B (4/21/2016)
I said 2. What is wrong with me.

You read T-R-Y-_-C-O-N-V-E-R-T as S-U-B-S-T-R-I-N-G

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

Explanation was incorrect. I had char and varchar, instead of nchar and nvarchar as the datatypes where an error should be returned.

Apologies for that. It has been corrected. I have also added an image of this running on SQL 2012.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Pher (4/21/2016)
Using SQL 2012
-- Msg 195, Level 15, State 10, Line 5
-- 'NVARCHAR' is not a recognized built-in function name.
-- The TRY_Convert function requires 3 argument(s).
SELECT TRY_CONVERT(NVARCHAR(1), 234523)
Did I miss something?

No idea.

This is what I get:

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

I thought it was a fairly straightforward question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

akljfhnlaflkj

SSC Guru

Points: 76202

April 25, 2016 at 6:42 am

#1874199

Thanks for the question.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP