It depends.

There are always cases where "the rules" need to be broken.

In a case like that, with 30+ FKs needed, that gets into the realms of both (a) you probably...

Phil Parkin (12/18/2012)

---

I saw an example only today of over-zealous use of the semi-colon terminator, with something like this:

Begin try;

--do stuff

End try

Begin Catch

--error handling stuff here

End Catch;

This does not generate...

SQLRNNR (12/18/2012)

---

Stefan Krzywicki (12/18/2012)

---

Brandie Tarvin (12/18/2012)

---

Has anyone else noticed that winter starts on the very same day that the world ends?

How does that work, wonders the author...

Happy Holidays for those...

Bill Nicolich (12/18/2012)

---

Thanks for the book citation. I'll have to...

GilaMonster (12/18/2012)

---

GSquared (12/18/2012)

---

Amusingly enough, Mayans vs Vikings is part of one of the dungeons in The Secret World. Apparently the Vikings brought Excalibur to North America and used it...

Upload the picture using the Edit Attachments button below the editing window. Then use the link for that.

(If you Quote my post, you'll see how I formatted the link....

Stefan Krzywicki (12/18/2012)

---

Brandie Tarvin (12/18/2012)

---

Has anyone else noticed that winter starts on the very same day that the world ends?

How does that work, wonders the author...

Happy Holidays for those currently...

ApexSQL sells a product that will do the work for you on that. Easier than...

Brandie Tarvin (12/18/2012)

---

Has anyone else noticed that winter starts on the very same day that the world ends?

How does that work, wonders the author...

Happy Holidays for those currently celebrating, for...

ganeshmuthuvelu (12/18/2012)

---

I am the OP here. It appears that the thread became a discsussion for whether indexes are needed on temp tables or not. I can say for sure that...

If you want to force the order by using the ID column, then force the ID column to have the values you want:

CREATE TABLE #varchar_field1

(ID INT...

Eugene Elutin (12/18/2012)

---

To SELKO:

GSquared (12/18/2012)

---

...

So your point doesn't actually prove your point, if you get my point. 😀

On the other hand, code portability has certainly worked out well for you....

With Audra and the Antidote's "We Wish You A ..." (http://www.lyricstime.com/audra-and-the-antidote-we-wish-you-a-lyrics.html) going through my head, here's wishing everyone here a merry Christmas and happy new year.

Carse's concept of looking at life as a game isn't anything new. It's been a key part of Scientology, for example, since the early 1950s. There's actually nothing...

For the future, you can use CDC (Change Data Capture) to get that kind of thing.

In order to track down past changes, you'll need to check the transaction log. ...