mstjean (7/13/2009)

---

>someone decided that 12/31/9999 was going to be the end date

Oh, just GREAT.

That means when Y10K rolls around, we're gonna hafta listen to the Mac camp brag about their...

Michael Valentine Jones (7/13/2009)

---

In any case, there is a lot worse advice out there than “Never use Cursors”. In the world of bad advice, it’s kind of fail-safe bad...

Jeff Moden (7/13/2009)

---

Heh... well... you can if you don't mind getting your lips dirty. ...

zenrigar (7/10/2009)

---

Oh then that was the trick, thanks alot for the explanation :w00t:

i also checked the link of your post and it was helpful too, now im curious about...

Michael Valentine Jones (7/10/2009)

---

19000107 is Sunday, Jan 7, 1900.

The code finds the number of day since 1900-01-07, divides by 7 to get the number of weeks since than, and adds...

You mentioned the word "function" in there in conjunction with returning data. Without specifics it's going to be hard to be useful, but in something complicated like what you...

sqlguru (7/8/2009)

---

Matt Miller (7/8/2009)

---

I will slither out from under my rock for a sec. If you use pointers instead of actual keys - how do you ever CHANGE a...

I don't know if it's related - but I am seeing a LOT of duplicate posts. Including answers of mine to issues now showing up twice. I know...

I will slither out from under my rock for a sec. If you use pointers instead of actual keys - how do you ever CHANGE a foreign key? ...

I will slither out from under my rock for a sec. If you use pointers instead of actual keys - how do you ever CHANGE a foreign key? ...

Look as the Raiserror() function

Just think how much he's hating us for...

GSquared (7/6/2009)

---

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt...

what happens if you cast to FLOAT instead of Numeric(18,2)? Your cast will go BOOM if you have more than 16 before the decimal.

- If the insert has an error, the function didn't fire.

- SQL Server considers Functions to be "no modify", so by their design, they are not supposed to make...