Yeah, that's from SQL Prompt. The Snippets function will do a bunch of work for you. Type cci and hit return.

It fills out all the code needed for making a...

If you're returning rows of data, just use a result set. But if you're returning a single row with only a few columns, output parameters are faster. It requires less...

Unless you've changed the default security on the machine (a good idea to do), you should be able to access the instance by being added to the local admin group...

In terms of security, you shouldn't have any concerns, assuming you properly wall off the IIS server. Performance could be a serious issue, depending on how much memory and processor...

You could also set the database to restricted user and use rollback immediate, assuming the connection that keeps getting in is not an admin connection.

With great power comes great responsibility. I only use it when I have to. 😀

It really has...

I'm ashamed to say I'm only reading about 15-20 books a year, a mix of novels, history & technical. It was so much more before the kids got older and...

Excellent feedback. Thanks everyone.

David Webb (7/23/2009)

---

For the younger crowd, I'd stay away from Delaney. His "Dhalgren" is perhaps the strangest book ever written and x-rated to boot. As a work of...

Bruce W Cassidy (7/23/2009)

---

[font="Verdana"]It's beaten out in weirdness by "Stars In...

VALIS and UBIK were the light stuff. You should read his...

Kit G (7/23/2009)

---

Yes, Philip K Dick is an acquired taste. Personally, I can't read his books but, in my opinion, they make pretty good movies. I love Blade...

David Webb (7/23/2009)

---

Andre Norton has some excellent material for that age. I'd recommend Star Man's Son.

I'd also recommend Zelazny's "A Night in the Lonesome October" for anyone, like me,...

Jeff Moden (7/23/2009)

---

The 10 book series called "John Carter of Mars" written by Edgar Rice Burroughs. Speculation is that he died before he wrote the 10th novel and someone...

Gaby A. (7/23/2009)

---

I've heard the book is so much better than...