su_kumar11 (7/21/2008)

---

I have tried to write as follows but its working...

CREATE TRIGGER LEAVE_TRIGGER

ON EMP

FOR insert,UPDATE

AS

DECLARE @LEAVE INT

DECLARE @EMPID INT

BEGIN

insert into EMPDET values (@empid,@leave)

update emp set emp.leave =...

Actually yes , it is the Monday article and though I had made a comment on the grammar being annoying, I wasn't too pleased to see so many comments on...

How do I delete this post. Doesn't seem to be right to ask this question.

Good article but the typos/spellings were a little annoying.

How do I raise an exception/error if one of the files doesn't execute properly.

Rosh

"If there are common patterns to how you call this, then you could try splitting it into multiple subprocs based on the values passed in."

This is what I am looking...

Its a search query ..........so we need not get all the inputs. or we might get all....

if it is a numeric data and not to be searched then we...

Tried the Index Tuning Wizard. Just recommends an existing index. Not much help that.

Yes, I mean the same.

Does Employee table have any existing data?

The query used in the article is what I was planning to use in the function. My problem is that the client doesnt want to be database centric, though...

Nope no temp tables. I guess will have to rely on the front end to get this done.

On the contrary performance is the key criteria here. I guess the data I have provided is quite simplistic to assume that. I know how to get this done without...

I need it in sql server 2000.

But thanks!!!

I guess I was so time pressed to get the answer that I didnt frame the question well. I have a database which will be set for replication later. I...