I think you can use something like this:

CREATE FUNCTION PureNumeric

(

@STRING VARCHAR(255)

)

RETURNS BIT

AS

BEGIN

IF ISNUMERIC(@STRING) = 1

BEGIN

IF (CHARINDEX('D', @STRING) <> 0) OR (CHARINDEX('E', @STRING) <> 0) OR ( CHARINDEX('$', @STRING) <> 0)

RETURN...

ng949 (3/20/2008)

---

Hi,

I am trying to write a SQL statement to find related videos in a video site for a particular video. The TAG terms under a video goes as a...

Jack Corbett (3/4/2008)

---

IMO, replication is going to be the easiest thing to setup. With replication you set up the publication(s) and subscribers and SQL Server does the rest. ...

Nicely done :). Actually, I've never checked the "existence" of those...

Hi,

I would recommend you to use a %NT% over the fields.

However, you should check the architecture of the app. Maybe you can make regular searches on the data en build...

Hi,

I don't understand what you want...

However, I...

True.

Remember that you can have as many triggers as you want, even for the same event.

Regardless of that, I guess you can try to check the existance of the INSERTED...

That's true, scheduled or regular shrink is a bad practice, in paper.

Sometimes there isn't enough time to fix the App and we need to solve things on the run. Change...

Hi,

I think that's the issue isn't only the usefulness of the script. The script itself it's ugly :p

Actually, you should be getting first the recovery mode of the DB and...