Viewing 15 posts - 37,966 through 37,980 (of 39,456 total)
Chris,
Great article. One question, what Oracle reference did you use? Row level security is an interesting topic, and one I've dealt with in a few places. I should probably write...
February 18, 2002 at 10:58 am
FYI. Pls try to avoid dynamic sql if you can. There is often a better solution.
Steve Jones
February 18, 2002 at 10:44 am
February 18, 2002 at 10:41 am
One thing I can suggest is to remove the <>. Since you cannot test for a non-existence without scanning everything, these tend to be inefficient. If it's only positive numbers,...
February 18, 2002 at 10:37 am
You should have both procedures. When you open the code, the old object, still exists on the server. When you recompile into the new object, you are creating a new...
February 18, 2002 at 10:33 am
Get the results in text or better yet, run this from osql and pipe the results to a file. You will have the header, but that is easily deleted.
Steve Jones
February 18, 2002 at 10:13 am
February 18, 2002 at 9:55 am
Thanks for the update. For anyone reading, the correct way to do this is:
CREATE TRIGGER [tr_addtotimeline] ON [paper_orders]
FOR INSERT
AS
DECLARE @publication_id INT
DECLARE @delivery_date DATETIME
/* get pub_id and date from the...
February 18, 2002 at 9:52 am
I tend to agree with Andy from your description.
I've run some inventory things and for reconciliation and high accuracy, we used to use separate tables for calculations.
Steve Jones
February 18, 2002 at 9:48 am
Yikes. Can't see doing that. I'd have to strangle someone if they insisted on my sending them a db to update.
Steve Jones
February 16, 2002 at 11:03 am
February 16, 2002 at 10:56 am
February 15, 2002 at 4:31 pm
Not sure what's wrong. I'd try the install and then search for all files changed in the last day. Should clue you in.
Steve Jones
February 15, 2002 at 4:28 pm
February 15, 2002 at 3:46 pm
no reg expressions. I have a tamestrings series that looks at some tricks, but none are really a "grep".
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
February 15, 2002 at 3:45 pm
Viewing 15 posts - 37,966 through 37,980 (of 39,456 total)