Yes, that is true. Luckily i managed to figure the code out.

Thanks for all your help!

Thanks!

I'll check it out...

No idea. I just know because I asked the same question about a year ago and someone smarter told me that.

Damn, I never get the chance to shine

Oh, forgot about that one. That's a better way of doing it if you just want to count all the rows i the table. But if you need a WHERE...

You should use SELECT COUNT(some_column) instead. If you use the *-sign you get much more I/O.

Hehe! Already read that one

quote:

---

Maybe you'll get some ideas here:

http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

---

Great article! Thanks Frank!

/Tomi

Oh, I see... Thanks again!

/Tomi

Well, that's exactly what I'm looking for! I guess I can have a limit...

Thanks a lot!

/Tomi

Hi Frank!

Ok, here's what I want to do:

I have a search page on my website where people can enter lots of search conditions. They can also leave all the conditions...

Thanks, Antares!

So multiple SPs is the way to go? I thought there'd be a simpler way...

Not that it's any easier but would sp_executeSQL also be a good alternative? I mean,...

Thanks again, Frank!

quote:

---

...assign something at least valid, ...

---

Now, this is where my problem is. I...

Thanks, Frank!

Yes, I know I can specify a default value to parameters in a SP. That's what I've done with my example:

CREATE PROCEDURE whatever



@param varchar(50) =...

Thanks McCork!

quote:

---

Why don't you check for existence of the key before any attempt to insert?

---

Yes,...

I think you should consider a complete redesign of the navigation menu or maybe even the whole site (but don't you dare touch that logo!). That would spice things up!...