quote:

---

Declaring it as inputoutput should work. Have you verified that your proc is working by adding a print after the set? Also,...

quote:

---

Why not just set you PK field to non-autogenerated and since PK's are unique the value comming in from Oracles PK should...

What they mean by Dynamic SQL is that ,

Decide what Ideally your SQL should look like.

I think there is still some haziness over there.

Then decide what is dymanic in that...

Hi,

I am quite late in the discussion.

But the problem with your query is that it needs a select rather than a Set.

___________________________________

CREATE TRIGGER photo_numbers

ON mls_photo

FOR INSERT , UPDATE

as

declare @PhotoState...

Hi,

I was avoiding Dynamic SQL for Performance benefit of the compiled Query Plan.

One more reason for this is that I expect this function to be called the most in my...

Hello ,

I ultimately implemented what Steve suggested.

I realised that

1) My Trigger option has a Rollback Overhead

2) The SP otion has a performance overhead.

The reason I was not happy...

Hello,

I did not answer Andy Warren's Question.

Why do I need to have informative Server Side Error Messages if I am already doing client side validation?

The "Enable Javascript" is a...

Hello,

The SQL Server version is 7.0

I am using ASP.

Yes, I would like the Error Message to be Informative to the max possible extent.

Hence this effort to push the...