Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-11-18 : 09:57:45
|
| Yes:http://msdn.microsoft.com/en-us/library/bb500435(SQL.110).aspxJezemine posted this in the thread from last week:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=152742 |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-19 : 05:49:46
|
I went to it from Jezemine's thread but didn't realise the URL had been sawn off ("(SQL.110).aspx" missing) - so what I got was SQL2008R2 What's New list and I ignored it  These caught my eye:Database Engine:EXECUTE allows definition of Result Set(s) - might facilitate INSERT INTO for Sprocs that return 2+ resultsets? Or just to make sure that the EXECUTE Resulset has not changed from expected definitionORDER BY has OFFSET and FETCH - to allow easy retrieve of rows 11-20 (representing "Page 2") (Are these the keywords already in use by other database vendors / ANSI - or is this another maverick naming convention? "LIMIT" seems to stick in my mind from other RDBMS Vendors)Developers:Enhancements to SSMS - improved utilities for debugging; more intellisense (which I don't use much anyway)SHA2_256, and SHA2_512 supported in HASHBYTESEnhancements to Full-Text SearchSequence numbers (like IDENTITY) pool usable across tables etc.Admin:User logins transportable with the database to a new server ("Contained databases")Easier config of Startup Parameters (less of a chicken&egg between needing to have the DB started to be able to change them, I guess)Audit tools |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 05:58:06
|
| Think ansi 2008 is offset fetch first rows only==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-19 : 06:13:00
|
| The DOCs do have "ANSI compatibility" after a couple of the keywords ... seems a bit daft if no RDBMS vendor was using that ... but maybe the ones using LIMIT all have their own home-brew syntax variants of LIMIT such that a new set of keywords resolves compatibility. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-11-19 : 10:00:56
|
it's ok. used to being ignored. ;)
elsasoft.org |
|
|
|
|
|
|
Denali?