|
sorry for off topic
i am deleting more than 1 records from a
single table
now i have an log table
i want to write log in log table
now i want all records shoud be loggd in log table
with one row for each
when i use
select @EmpName from deleted
and user insert into log values ( @EmpName
)
if there is more than one record
deleted
in log table i get only one row
i want to use cursor for logging
but if there is delete trigger runs for different
conns there is an error
cursor all ready exist
how can i create dynamic cursor name
??
have any one from list face this type of
problem??
plese reply
|
- Re: dynamic cursor in sql Niraj Soni
- Re: dynamic cursor in sql ShuSheng Li
