I'm really digging the new lag(), lead(), iif(), choose(), first_value(), and last_value() functions. Very nice stuff!
-Josh
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
-
Jsoh
:::Windows 8 Style UI :::
-
davewill
here birdie birdie, get in my belly!
Definitely. The lag() and lead() in particular could allow scenarios that were commonplace using Btrieve. That is definitely something that I majorly missed when moving to SQL.
-
Jsoh
:::Windows 8 Style UI :::
@davewill: It also looks like we get running totals via sum(y) over (order by x). Whoot!
-Josh
-
4 hours ago, JoshRoss wrote
I'm really digging the new lag(), lead(), iif(), choose(), first_value(), and last_value() functions. Very nice stuff!
-Josh
I remember IIF() from the VFP days. The CASE syntax is damn fugly in comparison.
-
cheong
Recent Cheevo unlocked: You got cookied!
Too bad our projects are moving to Entity Framework... We can't enjoy any of these unless we create a storeproc to run them...
And btw, every time I have to write a stored procedure because there's a feature I needed missing or performed inefficiently in EF. I'm at loss... what good does it brings over standard strong typed dataset if you only use storeproc to perform database access? /rant
-
Jsoh
:::Windows 8 Style UI :::
@cheong: You could still create a view, that solves your performance issues, and EF to that. And unless I'm wrong, you could also use table functions, and still get strong typing.
-Josh
-
cheong
Recent Cheevo unlocked: You got cookied!
@JoshRoss: Yes. This is exactly why I wonder what does I gain by using EF. I could just use System.Data.ODBC.* (Note that in MSSQL vNext, ODBC will become first class citizen and OLEDB will be dropped in vNextNext) to get strongly typed dataset to get virtually all what EF offers, without concern about performance issues.
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.