Viewing 15 posts - 22,021 through 22,035 (of 26,490 total)
Milan Sadil (3/12/2009)
Table2 - personID, badgeID, validFrom, validUntil
I would need to create a query that would result in the folowing:
firstName, lastName, badgeID
whereas:
- only valid badgeID (understand...
March 13, 2009 at 9:42 am
GilaMonster (3/13/2009)
Am I being too harsh here?
Nope, not too harsh in my opinion.
March 13, 2009 at 9:20 am
Unfortunately what you have does not work. Try it with the other criteria you stated earlier, it still returns 1.99.
Also, unfortunately, I don't have time right now to look...
March 13, 2009 at 9:12 am
Richard Briggs (3/13/2009)
Richard Briggs (3/13/2009)
as regards my own post on creating a CALCULATED PERSISTED column containing 'Age'.
I have discovered that actually because GetDate() is non-deterministic such a column cannot be...
March 13, 2009 at 8:27 am
Oh Boy! Double Posted Interview Questions that OP couldn't answer, here, and here
Really makes you want to jump right and help, don't it? 😛
March 12, 2009 at 11:17 pm
prvreddy (3/12/2009)
Hi guys,Nobody gave definitions to all my questions.You are all giving links or BOL links.But, i need definition, please help me in this regard
Thanks
Vijay
Why rewrite things when you can...
March 12, 2009 at 10:25 pm
Mohit (3/12/2009)
You can use a function to do you check constraint ...
It still needs to be a TABLE level CHECK contraint.
March 12, 2009 at 3:06 pm
pklug (3/12/2009)
The basic operation of this will (should) be:
1. Customer selects a combination of 3 attributes, as shown in the...
March 12, 2009 at 3:05 pm
frankivey (3/12/2009)
GilaMonster (3/12/2009)
frankivey (3/12/2009)
"Yes, with a full backup because full backup of the database filegroup is just like getting a full backup of the database", which is trueIt is?
Yes...
March 12, 2009 at 3:03 pm
Start with this and go from there:
declare @price table (
PriceID int,
UnitPrice money
);
declare @PriceGroup table (
PriceID int,
...
March 12, 2009 at 2:45 pm
Nope. I still have BOL for SQL Server 2000 on one of my desktop systems. Read about SAVE TRANSACTION in BOL.
March 12, 2009 at 2:33 pm
SQL Guy (3/12/2009)
This table has :
phone_id (PK, identity),
user_id (FK),
phone_num,
decsription,
is_primary bit
The rule is that only one...
March 12, 2009 at 2:31 pm
GilaMonster (3/12/2009)
Lynn Pettis (3/12/2009)
I have to agree as well. I'd love to get Babylon 5 on DVD.http://www.amazon.com/Babylon-5-Complete-Television-5-Pack/dp/B0001M3MXY/
I just sent "she who must be obeyed" the link you provided.
We'll see...
March 12, 2009 at 2:23 pm
GilaMonster (3/12/2009)
Bob Hovious (3/12/2009)
I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.
It's available on...
March 12, 2009 at 2:04 pm
JacekO (3/12/2009)
That's my point. The proper nesting is not supported by the SQL. Maybe it's because of the violation of the ACID rules but it is not there.
I ...
March 12, 2009 at 1:51 pm
Viewing 15 posts - 22,021 through 22,035 (of 26,490 total)