That would be a custom error, most likely. Check for that.

Honestly, if I were you, I'd set up a proof-of-concept database, try some sample data that way, and see if it does what you need and what you expect.

It sounds...

How do you do what? Store a date with midnight as the time? That'll depend on how you're getting the data into the table. What does your...

toddasd (6/2/2011)

---

GSquared, I think it would be a wonderful thing to sit at a bar and have some beers with you. We would probably spend the whole night debating when...

mtillman-921105 (6/2/2011)

---

toddasd (6/2/2011)

---

GSquared, I think it would be a wonderful thing to sit at a bar and have some beers with you. We would probably spend the whole night debating...

In SQL 2008, there's a Date datatype that can do this. In 2005 and before, the usual thing to do is store a date with midnight as the time.

I'm not sure what you mean. I'm assuming "alram tables" is a typo for "alarm tables", but even that doesn't clarify the question for me.

Stefan Krzywicki (6/2/2011)

---

Jim Murphy (6/2/2011)

---

Ha! Maybe you'll all have to...

Per http://www.thefreedictionary.com/null, yes, since null is a synonym for zero.

However, most DBAs would assume that null = no assigned value, not null = 0 (linguistic equality as well as mathematic,...

Generally speaking, it's best to separate IIS and web pages/application from SQL Server, but I understand that can't always be done.

SQL Server Native Client is a way to connect to...

WayneS (6/2/2011)

---

Does anyone have any experience with SQL XDetails[/url]? I saw a link on the site here, and am wondering what others think. Also... the link implies a free version,...

Of course it's true, so long as the ellipse there really means "repeating more nines infinitely".

1/3*3=1

Anyone care to argue with that?

A=B

B=C

hence A=C

Anyone care to argue with that?

If those are true,...

Try it without the quotation marks.

CREATE TABLE #T (

C1 VARBINARY(10));

INSERT INTO #T (C1)

VALUES (0x1234),(0x4567);

SELECT *

FROM #T

WHERE C1 = '0x1234';

SELECT *

FROM #T

WHERE C1 = 0x1234;

The first one will return 0 rows,...

Jan Van der Eecken (6/1/2011)

---

Brings me back to the beginning of my days (pun intended). A different language entirely:

10 Print "I'm not a Re-Curser but I am a Re-Cursor."

20...

Glad I could help.

Let me know if any of the Cross Apply stuff doesn't make sense.