-
how to skip lines while procedure executing by other user ?
Hi,
how to skip lines while procedure executing by other user ?
example
create sp_test
as
--#1
delete from x where a = 1
--#2
delete from x where a = 2
--#3
delete from x where a = 3
--#4
select * from x
user A executing sp_test
if user B executing sp_test at the same time run sp_test but skip #1; #3
Thanks
Alex
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|