Forum Replies Created
Viewing 15 posts - 57,436 through 57,450 (of 59,066 total)
-
RE: Pass a value to a trigger...
I guess I don't understand... obviously, you are finding the correct Windows user name somewhere along the line in your stored procedure because you want to "pass it" to a...
-
RE: syntax error.
It's the triple quotes in the variable assignment that are the most recent problem...
Try this...
declare @townID varchar(25),
@sql varchar(1000)
set @townID = '00003' --<<THIS IS WHERE THE...
-
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...
Viewing 15 posts - 57,436 through 57,450 (of 59,066 total)