February 24, 2014 at 12:48 am
Coming from 2000, there are new statements in 2005, 2008 and 2012. I once tried a new one only to find out if wasn't for the version we were using.
February 24, 2014 at 9:11 am
I'm not sure what you mean? Do you mean mark articles with a version?
The articles that mention newer code specifically tend to note the version. If the version has been out awhile, it's not easy for authors to remember which versions it applies to.
If you are using SQL 2000, you should expect that vast majority of articles written will not apply to your version.
February 24, 2014 at 10:52 pm
Yes, for example, sample codes, solutions with EXCEPT is for version 2005 and above. Then an article is for 2008 and above, and another is 2012 only.
This is beginner friendly. For me who will be stuck for a few more years in a version, I would know which new functions and words to concentrate should we upgrade to the next version, never mind if our upgrade is one or two versions below the current SQL version.
Which reminds me, is there be a section on 'What's New With This SQL YYYY Version', which would be about 3 sections.
February 25, 2014 at 7:40 am
Open Minded (2/24/2014)
Yes, for example, sample codes, solutions with EXCEPT is for version 2005 and above. Then an article is for 2008 and above, and another is 2012 only.This is beginner friendly. For me who will be stuck for a few more years in a version, I would know which new functions and words to concentrate should we upgrade to the next version, never mind if our upgrade is one or two versions below the current SQL version.
Which reminds me, is there be a section on 'What's New With This SQL YYYY Version', which would be about 3 sections.
You should BOL. Each release has a "What's New" page.
I hate to tell you but since you are on 2000 you are NOT one or two versions behind current. You are 4 major releases behind (2005, 2008, 2008R2, 2012). In another month or two you will be 5 versions (and 14 years) behind when 2014 is released.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply