Forum Replies Created
Viewing 15 posts - 57,421 through 57,435 (of 59,049 total)
-
RE: Count Decimal Places
Old guys rule...
1 million conversions... 11 seconds... works for positive numbers, negative numbers, zero, and NULL...DECLARE @Places INT
SELECT TOP 1000000...
-
RE: Trigger issue
If you run this code, you might just want to have your DBA turn on Trace Flag 1204 just to be safe
RE: Generic Audit Trigger
Ok... here it is... sans cursors... just so you know, I have NOT tested this particular code.
There are a couple of other things you need to know...
- You need to...
RE: Generic Audit Trigger
Oh jeez... If you're going to insult me with a cursor
Just kidding a bit... lemme see what I can do... I'll be back...
RE: Generic Audit Trigger
William is correct... if you update a column to the same value, it will register as being updated even though it has the same value... it's up to your code...
RE: Converting to int and aggregating at the same time
You can use the PatIndex if you want... I prefer the regular expressions because they seem to be simpler and they run with good speed...
For example, if you had...
RE: Generic Audit Trigger
Dang... fat fingered that one
Meant to say that the deleted table is empty for INSERTs... thanks for the catch, David.RE: Split a field into multiple records
First... replace all the CHAR(13) occurances with ';' including the single quotes. Some use similar code to make a function where they can pass the delimiter to the function but...
RE: Self Eliminated Parameters
Maybe that's the difference... I'm running SQL Sever 2000 Enterprise Edition with SP4. Just kidding... I get the same execution plans on an SP3a box as well. I don't know...
RE: What makes it faster?
As a self-taught newbie, I guess when it comes to the "religion", I don't have a lot of the...
RE: What makes it faster?
My managers at work liked it so well, they allowed the term in our coding standards... and, ALL the developers know what RBAR means... no need for a lengthy explanation...
RE: Converting to int and aggregating at the same time
ISNUMERIC does NOT check for numeric characters only... be careful.
RE: Generic Audit Trigger
Your code to handle the header appears to have a couple of a problems... as you are aware, the Deleted table is empty for Deletes... why does the SELECT in the...
RE: Generic Audit Trigger
>>Then generate the header record and pick up its unique id – (how do I get this).
Right after you insert into the header table, do a SELECT @variable = SCOPE_IDENTITY()...
RE: Generic Audit Trigger
Aren't you missing a "TableName" or TableID column?
Viewing 15 posts - 57,421 through 57,435 (of 59,049 total)