Viewing 15 posts - 10,201 through 10,215 (of 14,953 total)
Lynn Pettis (4/1/2009)
Hey Bob! He's back!
And double-posting!
April 1, 2009 at 8:49 am
I'm afraid I don't follow what you're trying to do. What precisely do you mean by "I want to capture a case"? Are you talking about logging something,...
April 1, 2009 at 8:40 am
Lynn Pettis (4/1/2009)
April 1, 2009 at 8:38 am
I keep looking for SSC's hostile takeover over SQL Server from MS. 🙂
April 1, 2009 at 8:37 am
It looks like each customer number always has the same data for first and last name, just different data for first name 1, and last name 1. Is that...
April 1, 2009 at 7:18 am
If you don't need to audit col2 and col3, why include them in the select statement in the trigger? Why include them in the audit table?
April 1, 2009 at 7:10 am
arr.nagaraj (4/1/2009)
[n1] [int] not null,
[n2] [int] not null,
[n3] as n1 + n2 ,
[n4] as n1 * n2
CONSTRAINT [t3_unique_key] unique (n3,n4)
...
April 1, 2009 at 7:04 am
That's correct. To achieve that, you have to set the isolation level to "read uncommitted". It's a related, but slightly different, thing.
April 1, 2009 at 6:54 am
You can use the Update() function for this, if you prefer column names over ordinal positions.
March 31, 2009 at 2:18 pm
jfox (3/31/2009)
March 31, 2009 at 2:16 pm
JJ B (3/31/2009)
March 31, 2009 at 2:11 pm
Sergiy (3/31/2009)
GSquared, correlated subquery is bad enough by itself, but 2 correlated subqueries in a single query - it's just a killer.
Oh, that's nothing. It's also got functions on...
March 31, 2009 at 2:04 pm
mlang (3/31/2009)
The problem in this is that it's very hard to prove "lack of intent", just as it's hard to prove any negative. With lawyers and courts operating on...
March 31, 2009 at 2:00 pm
Steve Jones Note that if you're not social in the real world, you probably won't like these things. If you don't like to talk about your life with co-workers, alumni,...
March 31, 2009 at 1:54 pm
Viewing 15 posts - 10,201 through 10,215 (of 14,953 total)