PARSE

Question

PARSE

Matthew McGiffen

SSChasing Mays

Points: 653
More actions
July 23, 2018 at 11:14 pm

#372511

Comments posted to this topic are about the item PARSE

Viewing 4 posts - 1 through 3 (of 3 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

This is nice. I haven't really understood why was PARSE introduced and this gave me a better understanding. Some might argue that it wasn't needed while others will be forever thankful for it.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

stux SSC Rookie Points: 30 More actions · Answer 2

I didn't know there was a plain PARSE() function but it makes sense that it would also exist. Thanks for the detailed explanation.

I think a function that merits mention in the article is TRY_PARSE() (this is the function that I was familiar with). It's quite useful when you don't want data errors to kill your query or stored procedure, much like C#'s (data type).tryparse() functions!

Matthew McGiffen SSChasing Mays Points: 653 More actions · Answer 3

Hi Stux,
Thanks for the feedback.
I'm working on a separate article for TRY_PARSE, should be available on SSC in the next month or two.

PARSE

Cookies on SQLServerCentral