Sorry Jason - gotta part ways with ya here...

Sandy...

Generic the answer to your question is - yes, you can use multiple LIKE statements, but in your case - you're trying to do too many things in one, which...

Jack Corbett (11/29/2007)

---

I'm going to simply answer the question posed in the title.

Foreign Keys are a good practice. At the very least there is always at least 2 applications...

Nonsense - get...

Let's see if we can define it a little differently:

Using an example syntax of ....

X in (list)

...., the IN syntax compares X to each value and returns TRUE...

paulr (11/26/2007)

---

We have a Managed SQL server 2000 cluster running against a SAN disk set. At occasional peroids we seem to suffer a very high number of SQL Deadlocks and...

noeld (11/26/2007)

---

Not sure but maybe this is what you want ?

use ;

go

declare @vMin int, @vMax int, @vTotal int;

set @vTotal = 142607203;

set @vMin = 1;

set @vMax = 5000;

while @vmax <= @vTotal

begin

BEGIN...

Thanks! - when all of your end-users are doctors (who think of themselves as royalty), then you tend to have to play fireman a lot....:P

If you're on the highway a lot, without a lot of stopping and starting (which is apparently part of the trick required to recharge your hybrid), your Hybrid isn't going...

If you plan on doing this a lot - you should look at setting up a linked Server. That will allow you to access the data from a remote...

if you don't specify a style, your CAST syntax, and your CONVERT syntax should both return only 6 digits.

If on the other hand you try this:

convert(char,@radius,2) --the 2 is the...

I have the same issue for a while, so I submitted mine to a professional resume writer outfit, that seemed to help with that. You might care to give...

Philip Horan (11/28/2007)

---

Thanks guys. That explains why the consultant wants to mirror. Never considered a SAN for a shared disc array as I have never worked with SAN's. How does...

the char, varchar, nchar, nvarchar types will take any number of extended characters. It doesn't care that it can't display them.

Are you sure that Oracle isn't accepting them, and...

alain_smithers (11/28/2007)

---

In order to be useful for the reader who has no axe to grind, perhaps we can agree that the answer may be dependent on the type of application...