malleswarareddy_m (4/4/2010)

---

Good QOD.This Question gives good information about bit datatypes.

when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert it...

Simple and easy one.

The ultimate guide to the datetime datatypes

http://www.karaszi.com/SQLServer/info_datetime.asp#Why1753

Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D

Even tried to google it and found nothing much. Though...

The responsibility of QOD submitter is OK and it should be like that. But why readers? Readers should be responsible for a healthy discussion and not for answers in...

I agree with most of the replies that this article is misnamed as 'decoupling databases' rather than Designing database. But, the purpose of article is more served than intended...

Good question. The best part was image instead of text. By looking at the question I thought

/* The replace function requires 3 argument(s) */

would be the...

What a fluke. I got right. I thought it should be 0 but SSC would not post a simple question with 2 points. Apart from 0 only...

sjimmo (2/10/2010)

---

"it doesn't .. but you can create a sp instead when you want to use cte"

Matt32 - The question was about a view.

Why do so many complain about a...

Joan OBryan (2/8/2010)

---

The easiest way I found to recover in this scenario was to take the database OFFLINE (not detach!) and then bring it back ONLINE in Enterprise Manager. This...

Back to basics. Most of the time I select wrong answer for basic and simple question. Triggers are for INSERT, UPDATE, or DELETE only.

Very good question. I should had executed it on SSMS and then answered it. But, no I just read and answered and got it wrong.

Huh.....never used it. Ever. something new to think.

Thanks for the question.

I got 1,1 in sql server 2005 EE and SE sp3 and 2008 EE sp1.

But when tried in sql server 2000 EE sp4 I get 1,0. Question should...

Easy one.