Quote:
Originally Posted by MattP
I would love to be able to use LAG and LEAD.
|
You should use a proper database then; lag and lead have been in Oracle for at least 10 years..
I like some things about SQLServer, like.. er.. it works. And it integrates well with VS, but I'd happily forgo these minor perks because everything else about it on a basic level is plain retarded. Take the way ISNULL works; it sounds like it returns a boolean, but it's actually a crippled and stupid form of COALESCE. Another great example is date handling; if your date isnt in one of the 17 predefined formats that microsoft wants you to use, youre stuffed. Oracle has had methods that work like .NET's ParseExact for more than 10 years..
Mmm.. so, for me SQLServer "has the dumb" - I probably won't vote for LAG/LEAD because I'll just use Oracle
