Viewing 5 posts - 1 through 5 (of 5 total)
IF EXISTS(
SELECT *
FROM DELETED D INNER JOIN INSERTED I
ON D.PS_ID = I.PS_ID
WHERE D.Ps_PreBase <> I.Ps_PreBase
OR D.Ps_Costo <> I.Ps_Costo
OR D.Ps_PreVta <> I.Ps_PreVta
OR D.Ps_PreSug <> I.Ps_PreSug
)
BEGIN
BEGIN TRANSACTION
...
May 4, 2004 at 2:56 pm
how do I apply this same solution to commit every 1000 inserts??
March 31, 2004 at 11:03 am
Hi Chris, no you can still use DBO_ONLY in 2000. I forgot to reply to my own post when I figured out that I forgot to include With NORECOVERY on...
March 16, 2004 at 8:11 am
I have spent all morning trying to fix the same problem. It is strange, when I send a test email from EM it works fine the email gets sent and...
March 12, 2004 at 12:20 pm
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy