Very nice article. I agree with Old Hand with most recommendations.

I might consider using NVARCHAR instead of VARCHAR - for if you want to expand your book reviews to...

Hi,

Very nice article Brian.  Do you perhaps have an idea if this affects the performance of the system using the SQL server?

Cheers

Hi Naeem,

As Mikael said, there are many ways. I'm not sure exactly what you want, but you can just use the BETWEEN statement, for example using Northwind:

--These 2 variables are...

Charge everyone in the world sending emails something similar to a "postage fee" in normal postal services mail.

You can buy "stamps" from your email provider, and every email you send...

Hi,

I agree with Steve - join them up like

select a.*

from a

inner join b

on (a.f_name = b.f_name) or (a.f_name = b.m_name)

Then if you are only interested to find out if...

Hi,

You are right - I was busy changing this proc into dynamic SQL when I copied & pasted it into this - so this one doesn't work, just use straightforward...

Hi,

If the purpose of the input parameters are to specify which column to filter against, then rather change the stored procedure to take all the available columns as input parameters. ...

Hi,

Great article & good tips along the way in the reponses.  Keeping your stored procedures in a source controlled environment is as the article states rather tricky.  Using something like...

Malcolm,

Your point is well made and it is good advice.

Thanks

Christiaan

Hi,

Change Control management is required for the following reasons: You want to know who broke it.

Online systems like Flare or Rational Clearquest are helpful in maintaining who can request the...