x

What's new in T-SQL for Denali?

Ok, I'm probably being dumb, but I can't find a summary saying 'here is the new stuff you can do in T-SQL in Denali'.

There is obviously NEXT VALUE FOR, and support for paging - but is there a definitive 'this is what's new' post somewhere?

more ▼

asked Dec 03 '10 at 08:18 AM in Default

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

Matt - you really missed out not seeing Tobias Ternstrom from the SQL Programming Team (he is lead on programability -> T-SQL, CLR etc.) at the PASS Summit.

He showed the programability enhancements like THROW and the replacement for the borken SET FMTONLY. He is a great presenter and really funny.
Dec 03 '10 at 12:46 PM WilliamD
@WilliamD - Yeah, I know. It's the fact that the MSDN missed out THROW which leads me to wonder if there is a more definitive resource...
Dec 03 '10 at 01:07 PM Matt Whitfield ♦♦
Nah - definitive resources for stuff on an unfinished product. Even the MSDN stuff says that it is open to change, so no dice I think.
Dec 03 '10 at 01:17 PM WilliamD
Well, yeah, CTP1 isn't what RTM will be. But is the question 'what have you actually shipped' so hard to answer?! ;)
Dec 03 '10 at 02:55 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

4 answers: sort oldest

I liked this concise article from Aaron Bertrand.

For example, dual monitor support is new.

One part that's missing, at least so far according to Aaron, is the "bread crumb" feature that let's us click on an error message and it takes you to the error in the sproc. I especially liked that feature! ;0)

[Edit] The link mentioned above is hardly comprehensive. At times I wonder if I have reading comprehension problems! Anyway, you may have seen this and it doesn't claim to be an exhaustive list, but maybe [this][2] is more relevant to what you're asking.

[2]: http://sqlserver-training.com/sql-server-denali-new-features/-
more ▼

answered Dec 03 '10 at 08:59 AM

Mark gravatar image

Mark
2.6k 21 25 27

See... that one is missing THROW as well...
Dec 03 '10 at 01:09 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

You can get answers from [this][1] link.

[1]: http://msdn.microsoft.com/en-us/library/bb500435(SQL.110).aspx
more ▼

answered Dec 03 '10 at 08:58 AM

ozamora gravatar image

ozamora
1.4k 2 3 5

Yep - knew about that one, but the way that THROW is added in by a MSFT peep in the Community Content section irks me...
Dec 03 '10 at 01:08 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

In fairness Mark, I have written many blog posts focusing on different features introduced in Denali, including one on THROW. My list isn't comprehensive yet either (for example, I haven't yet blogged about AlwaysOn or the FMTONLY replacements). Here are a couple of links that might be useful to Matt.

This is a list of all the posts I've written and tagged with "denali" - this includes a slide deck of a "What's New in Denali" presentation I gave for the Philadelphia SQL Server User Group this week:

http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx

And here is an article on THROW specifically (which, as has been noted, did not make it into the CTP1 Books Online):

[http://sqlblog.com/blogs/aaron_bertrand/archive/2010/11/22/sql-server-v-next-denali-using-throw-instead-of-raiserror.aspx][2]

Just to clear up any misunderstanding, the Books Online process is not a simple "just throw a web page up there." In can often take weeks or longer to publish a simple page, since it has to be updated in several other places (all deep links, table of contents, index, etc) and it also has to be translated (the CTP and Books Online ship in more than just English). Not saying THROW shouldn't be there, but during the early beta phase we have to compromise. If it's a choice between getting the product with some docs missing, and waiting for complete docs (which will never happen during dev, because dev and doc do not move at the same speed), I know what I would vote for.

[2]: http://sqlblog.com/blogs/aaron_bertrand/archive/2010/11/22/sql-server-v-next-denali-using-throw-instead-of-raiserror.aspx
more ▼

answered Dec 10 '10 at 02:31 PM

AaronBertrand gravatar image

AaronBertrand
905 1 3

@AaronBertrand - Thanks - the thing i was looking for wasn't a Books Online section - or a series of posts - just a single blog post or something like that, maybe from one of the SQL Engine team, basically summarising what's new in T-SQL. Even just a dump of the differences in the BNF between 2008 and 2011 would be invaluable.
Dec 13 '10 at 12:17 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

I have compiled a large list of features (around 60+) and blog posts and articles explaining each feature. You can find it here: [What is new in SQL Server Denali][1]

[1]: http://beyondrelational.com/whatisnew/sqlserver/denali/
more ▼

answered Jan 30 '11 at 06:24 PM

Jacob 1 gravatar image

Jacob 1
21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x976
x13

asked: Dec 03 '10 at 08:18 AM

Seen: 1838 times

Last Updated: Dec 03 '10 at 08:18 AM