Sure, there's a whole section of Books Online about it:

http://technet.microsoft.com/en-us/library/ms186973.aspx

Well I'm a reasonable (code) typist, but to my shame I...

Steve!!! Ten points please!

Ninja's_RGR'us (5/27/2010)

---

Also if you can't part with a measly 200$ - 300$ for something that will help you make more money and better server your clients then you really need...

Cascading DELETE with an action of SET NULL or SET DEFAULT

Steve Jones - Editor (5/27/2010)

---

Why not? Just curious. If it really...

UPDATE LazyMaddy

SET cpnt = LazyMaddy.q

FROM (

SELECT T.cpnt,

...

There's no way it should take 30 seconds 😀

Z.A.T (5/27/2010)

---

I run solved this query then I answerd NULL, because you forget to write

select @hourDiff

in your query.

so my answer is write NULL.

if you wrote select @hourDiff...

Dave Ballantyne (5/27/2010)

---

I find intellisense and its most annoying when putting together test code , ie where im quite happy for a column called 'A','B' or 'ID'. Can never...

Jason and Steve: turn it off then 😛

I love IntelliSense on the whole, and I really miss it when working with non-2008 servers. I think it's amazing it works...

Demonstration script (any edition of 2005+ required)

USE tempdb;

GO

-- Source table without IDENTITY

-- (PRIMARY KEY just for demonstration purposes)

CREATE TABLE dbo.Example

...

*sound of a mouthful of tea hitting an LCD screen at high speed*

MAXDOP 512

Hey, sorry for the slow reply, I...