LIKE and = Operators

Question

Post reply

LIKE and = Operators

Viewing 11 posts - 31 through 40 (of 40 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

TomThomson

SSC Guru

Points: 104773

December 7, 2010 at 6:32 am

#1259495

Good question. Made my brain ache. 😀

Tom

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Carlo Romagnano (12/7/2010)
When I realize that a command or option is deprecated, I stop to waste my time to use it.

My thoughts: It should be an alert to check existing code to determine how much of it will have to be altered to comply with the new rules. Doing so in advance allows one to gradually upgrade and properly test existing functions, T-SQL etc., so as to be fully prepared for an upgrade. But that is just my opinion.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

pjdiller SSC Eights! Points: 977 More actions · Answer 3

I guessed wrong. Figured I had a 1/128 chance of getting it right... can't win if you don't play.

jts2013 Hall of Fame Points: 3226 More actions · Answer 4

It would have been much clearer if the instructions to run the insert twice were in the question not hidden in the comments - I would probably still have got this wrong but at least I might have stood a chance!

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Great question, unfortunately I have not seen the comments with SET ANSI_PADDING ON/OFF. This is how I discovered I don't pay enough attention to comments 🙂

Regards,

Iulian

iBar SSCertifiable Points: 5872 More actions · Answer 6

Only lesson, i got from this question is to read the comments more carefully (run twice...) and thats why its just another dodge question.

Rose Bud Hall of Fame Points: 3147 More actions · Answer 7

QOTD doesn't get any better than this! It's obvious you paid a lot of attention to detail when you were writing it. And, you required us to pay a lot of attention to detail when answering it. I appreciate the effort you put into this!

Ron McCullough SSC Guru Points: 63877 More actions · Answer 8

MidBar (12/8/2010)
Only lesson, i got from this question is to read the comments more carefully (run twice...) and thats why its just another dodge question.

I would certainly hope that you read things such as project/program requirements carefully, or do you have a valid resume available so you can hunt for a new job on short notice.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Ron McCullough SSC Guru Points: 63877 More actions · Answer 9

wware (12/13/2010)
QOTD doesn't get any better than this! It's obvious you paid a lot of attention to detail when you were writing it. And, you required us to pay a lot of attention to detail when answering it. I appreciate the effort you put into this!

Many thanks for the compliment.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Thanks for the question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kiran.konankal SSC Veteran Points: 236 More actions · Answer 11

bitbucket-25253 (12/4/2010)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/71753/">LIKE and = Operators</A>

thanks. interesting topic.