Viewing 15 posts - 3,766 through 3,780 (of 7,636 total)
Paresh Prajapati (1/21/2009)
RBarryYoung (1/21/2009)
January 21, 2009 at 11:12 pm
Jeff Moden (1/21/2009)
RBarryYoung (1/21/2009)
Man, what a bonehead!And all that time.... I thought it was a helmet. 😉
No, no, no, dude! The helmet is to cover-up my bonehead.
January 21, 2009 at 10:07 pm
Responders should note that the request was for a unique number and not a random one.
Given the uniqueness of the counting numbers, that's probably a lot easier. 🙂
January 21, 2009 at 5:45 pm
Oops, I missed your reply too! Man we're getting slow... 😛
January 21, 2009 at 5:41 pm
Jeff Moden (1/21/2009)
RBarryYoung (1/21/2009)
January 21, 2009 at 5:40 pm
How "in synch" do they have to be?:
- What is the acceptable latency window?
- Does this have to handle Table Def changes also?
- What about changes to views, sprocs and...
January 21, 2009 at 5:33 pm
I think that trigger should be "all or nothing" Lowell. That's how Constraints work too.
January 21, 2009 at 5:27 pm
Well, I agree with your list Lowell. And I do use that link sometimes myself (mostly with my kids). But neither of those are the point of this...
January 21, 2009 at 5:22 pm
Heh. No, you're fine. I stink. 🙁
It seems that I cut and pasted the wrong query. Sorry, my bad.
Try this one instead.
select name, accdate...
January 21, 2009 at 4:46 pm
They say temp table I say subquery
I say "Test it."
As J. Hennessey, a founder of MIPS Technologies once said, "Don't argue. Measure."
January 21, 2009 at 4:08 pm
barbararyan (1/21/2009)
Is it necessary/mandatory to name the PK of all the subtype tables "PersonID"?
Necessary? No.
Mandatory? No.
A really good idea? Yes.
January 21, 2009 at 3:59 pm
Like this:
select * FROM INFORMATION_SCHEMA.PARAMETERS
January 21, 2009 at 3:50 pm
You cannot use ALTER TABLE to change the identity attribute of a column. Use Management Studio to do it.. it will magically recreate the table for this.
January 21, 2009 at 3:38 pm
Luke L (1/21/2009)
And I've been wondering for weeks why we have 2 Vaders running around here, or are you and Perry one in the same?
Hmm, I thought that Perry changed...
January 21, 2009 at 3:35 pm
Lynn Pettis (1/21/2009)
Use the Force Luke...
Doggone It! I've been waiting for weeks for an excuse to use that line on Luke!
😎
January 21, 2009 at 3:19 pm
Viewing 15 posts - 3,766 through 3,780 (of 7,636 total)