October 27, 2009 at 4:36 pm
Gift Peddie (10/27/2009)
Lynn,That is very good example but you will find most T-SQL developers write the old one even in SQL Server 2005 and 2008 and SQL Server in most cases executes it and returns correct results.
True, but they usually keep writing queries like because that is what they are comfortable with doing. I have been pushing hard here that all queries need to be written using ANSI STANDARD joins. It can be difficult at times even with queries that are all inner joins to determine what is a join criteria and what is a filter criteria.
Having started writing sql queries using the ANSI standard, it is second nature for me.
October 27, 2009 at 6:23 pm
Lynn Pettis (10/27/2009)
Gift Peddie (10/27/2009)
Lynn,That is very good example but you will find most T-SQL developers write the old one even in SQL Server 2005 and 2008 and SQL Server in most cases executes it and returns correct results.
True, but they usually keep writing queries like because that is what they are comfortable with doing. I have been pushing hard here that all queries need to be written using ANSI STANDARD joins. It can be difficult at times even with queries that are all inner joins to determine what is a join criteria and what is a filter criteria.
Having started writing sql queries using the ANSI standard, it is second nature for me.
Lynn,
So Chad knows there will be a very long thread when he posts his question.
😎
Kind regards,
Gift Peddie
October 27, 2009 at 9:32 pm
So Chad knows there will be a very long thread when he posts his question.
BWA HAHAHAHAHAHAHAHA! :w00t:
That was awesome.
I'll just put a link to this thread in the answer explination.
Whew. My sides hurt now.
Chad
October 28, 2009 at 8:22 am
Chad, please feel free to submit it. If it's new to you, it's probably new to 100s of others.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply