Viewing 11 posts - 241 through 252 (of 252 total)
If you can't touch the table structure, a loop using SET ROWCOUNT will limit the number of records deleted. Perhaps a cursor with using a select something like
SELECT...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 4, 2003 at 9:06 am
How about using a function?
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 2, 2003 at 1:08 pm
The identity increment can't be easily undone because another connection doing inserts into the same table might be affected.
A COMMIT or ROLLBACK will not affect the next identity value to...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 2, 2003 at 12:04 pm
The time to do most math calculations is small compared to network IO. I'd be very surprised if you could see much difference. An index on a wide...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
September 2, 2003 at 11:49 am
If you are only calling the insert from an application, perhaps a stored procedure with parameters collection can be used. A parameter defined as a string should not need...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 31, 2003 at 9:29 am
I coded a few triggers. Here's my 2 bits.
In the trigger you have access to the "inserted" and "deleted" tables. They will let you do set...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 25, 2003 at 1:03 pm
This has happened to me also. Would a statement like
RAISERROR('FYI: This message should be sent without delay', 10, 1) WITH NOWAIT
work for you? The severity is...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 24, 2003 at 9:51 am
The script library for this site has the code for a CDO proc called "sp_SQLSMTPMail". It might be worth checking out.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 14, 2003 at 9:37 am
You might try bol (bools online) for the topics "sp_executesql" and "Using sp_executesql". The object (e.g., table) names need to be fully qualified in order for SQL Server to...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 11, 2003 at 10:44 am
Make sure the table is ordered by the column in question unless you want the count to reset. The UPDATE statement does not permit the order by clause. ...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
July 11, 2003 at 10:06 am
Do not trust xp_sendmail in a trigger. We (County of Marin) have use Exchange with an Outlook client and have had trouble from time to time with email. ...
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
June 25, 2003 at 9:12 am
Viewing 11 posts - 241 through 252 (of 252 total)