No joke: Microsoft SQL Server 2012 debuts on April Fools' Day
As expected Microsoft has released SQL Server 2012, formerly codenamed Denali, to manufacturers and will be making the final code available on April Fools' Day. "This is the cusp of a major milestone for Microsoft and SQL Server," Doug Leland, GM of SQL marketing for Redmond told The Register. "It's been battle-tested by over …
This topic is closed for new posts.
it is broken
this wont' work in sql 2008
select 1 / i from x where i <> 0
divide can be done before where part is checked and it happened to me so i know it.
also m$ admit it is true here http://msdn.microsoft.com/en-us/library/ms188295%28v=sql.100%29.aspx
they make it look hard to happen but its easy. they dont tell people about it. they say it is faster but it is broken.
Re: it is broken
This article is not about SQL Server 2008.
Did you bother to read it?
Re: it is broken
-- a Common Table Expression will work :
With Safe_CTE as
(
SELECT i FROM x WHERE i <> 0
)
SELECT 1 / i FROM Safe_CTE
-- Of course, if i is an integer type, your results aren't going to be very useful!
Re: it is broken
no it is not certain even with cte. m$ write-up say how to make it safe the only way. and it is not a bug say m$ it is <<by design>> so maybe in sql 2012 also.
You'd have thought this would be Windows 8 release date judging by the joke that is Metro.
SQL server 2012.....Wait, What!
Well I suppose it's another upgrade path to consider, when my beloved SQL 2000 servers reach their end of life in 2013.
Newcastle really are doing well aren't they.
Just last week I notice all that Huawei. Now there's Hadoop.
I wonder what's next? Divvent? or maybe Keesyde I reckon.
Ya didnt need
An Oracle to figure that out , canot wait for the SQL
This topic is closed for new posts.
