This code is interesting but seems to be completly bugged :/
I ran the first sample : exec sp_sudoku_solve_simple '023780460000620000060304080001000534280000097439000100010205040000036000056018370'
the exposed solution is completly false, and almost alls initals...

vk-kirov (12/17/2009)

To those people who answered '1,3,4': is the condition 'all active tasks have stopped referencing them' sufficient for dropping the table? The answer is 'No, it is not'. If...

I totally disagree !

This ("When the session that created it ends") unchanged and without further explanation is false, because if there is another connection that accesses this global table it...

One more time (as usual ? as often ? ) , "all of these apply".

"doubly linked lists".

Well, i learn something today 🙂

I thought it was B-Tree.

I don't like questions where all answers are right, it don't learn us the limits, it makes me confusing,...

i d'ont understand...

I selected 'national character varying', told me is wrong and that the answer was ... 'national character varying' :blink:

Well, i'm surprising by the answer (thought about char(1) or nchar(1), and the answer is nvarchar(1) ?

MMmmmm... and what about the 2 bytes added in header ?

I can't agree !...

declare

@d1 decimal(38,10),

@d2 decimal(38,10)

SELECT

@d1 = 1.67574,

@d2 = 10000

SELECT

d1 = @d1,

d2 = @d2,

d1_div_d2 = @d1 / @d2,

cast_div = CAST(@d1 / @d2 AS DECIMAL(38,10)),

num_div = 1.67574 / 10000.0,

cast_num_div = CAST(1.67574 / 10000.0 AS...

well... i can't agree this one.

study through them, yes, learn throught them also, understanding, learning mechanisms is right.

Learning answers and become a parrot......

Yes, you knew Datetime.

But Sql Server 2008 provides new datatypes to store -between others - or only a date or only a time.

In the answer, you have a link to...

Lynn Pettis (11/30/2009)

There has...

I will personaly prefer to do something like cast(cast(getdate() as int) as datetime) to obtain de date of the day at midnight rather using datediff+dateadd functions.

So, it seems i'm not alone being trapped by create/schedule a job for the 2008 Express Edition 😀

Not an every day problem for us (hi from France ^^ ), but as we have to communicate in english for international, it is an usual question 😀