Thanks.

What threw me off was that I was under the false impression that I had to select fields in the where clause even if I didn't need them.

Thanks.

What threw me off was that I was under the false impression that I had to select fields in the where clause even if I didn't need them.

I'm trying to return just the calculated status variable.

I'll match the data type once I get this to compile and return a status.

Thanks for the s-p-e-e-d-y reply.

Thanks. That was very helpful info.

Disclaimer: I'm a newbie...

Am I correct that if you merely add a ROWVERSION column to your table that SS will prevent overwriting an interim change, but will not communicate that...

Alt-F1 works for me in Katmai Developer Edition (SS Ver 10). Looks handy. I am self taught (or rather, self learning) and there are a world of great ideas on...

Interesting to to see the two completely different approaches in action!

Thanks again.

Thanks for those responses.

I notice someone else using the syntax:

SELECT name, xusertype, xtype

FROM syscolumns

WHERE id=@id etc...

but upon closer inspection, that is the old SS2000 syntax, now called the COMPATIBILITY VIEW...

Ok, I have adapted this to my needs as follows:

* I changed it from a local temp table to a table so I could do all of the tables into...

Thanks. I wonder if you could show me how to do it. I tried this:

CREATE FUNCTION dbo.RegExValidate

(@expressionToValidate nVarChar(100),

@regularExpressionparameter_name nVarChar(100))

RETURNS bit

WITH IsDeterministic, IsPrecise

EXTERNAL NAME CTSWebStoredProcs.CTSStoredProcs.RegExValidate

GO

I didn't get squiggly lines, but...

Thanks for the reply. I've been successful and for the benefit of others who want to do this, I illustrate your steps with an example from my application....

First, I enable...

I realize that the Sql Server Project Template is only available in the Professional edition of VS but wouldn't it be possible to create a CLR proc by just creating...

Okay, I'm thinking that this is intended to be deployed as two separate scripts. To be more useful, I would suggest the following:

* have this automatically run for each table...

That makes sense. Thanks.

Ok, thanks. Then is there a way to know inside of my Trigger whence the trigger is being called - whether from the view or from the table?