Recent content by datamodeler

A stored procedure containing a "LOOP" statement that determines that it is a new day and calls one or more other procedures to do your deletions. Not sure how much of a resource hog this might be but it does stay within the dbms. If "LastDatePerformed" were written to some table, and this...

if you have, instead of "e.code in ....." the phrase "e.code = '18', do you only get what you expect? if your answere is yes, try unioning three queries together mike harris Mike Harris Data Modeling & Administration

Thanks While I believe it ought to be possible, in the primary key phrase of the constraint clause of create table, to indicate that the index so created should be clustering, at least this gives me a way to do it should I so desire. Mike Mike Harris Data Modeling & Administration

If I define a primary key constraint, the system will create an index for me. That is fine. How do I get it to be the cluster index for the table? Should I simply define a unique index but not indicate that it is the primary key? I do not like this because of the loss of metadata. Any...

I have multiple update triggers defined on table "XXX". Does each of them, when it fires, see the identically same "new" and "old" tables? Does "new" contain ALL columns of table "XXX" even though only some of them are updated? What about "old"? Mike Harris Data Modeling & Administration

Perhaps I am blind or just dumb but I cannot figure out why this statement alter table PROD."mchTEST" alter createdat set default current_timestamp; produces this output alter table PROD."mchTEST" alter createdat set default current_timestamp DB21034E The command was processed as an SQL...

I want to be able to have an SQL Server 2000 trigger cause the execution of a mail merge within Word 2000. Unfortunately the informaion concering the sp_OA... stored procedures leaves something to be desired - in my opinion. Can anyone out there provide a small example? Mike Harris Data...