Viewing 15 posts - 1 through 15 (of 42 total)
This is what MSDN says (http://msdn.microsoft.com/en-us/library/ms191250.aspx):
A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name,...
January 31, 2012 at 3:33 pm
Of course I got it wrong as probably all others trying this question. And it does not matter if you try to answer with or without SSMS.
QotD should try to...
December 23, 2010 at 4:30 am
BOL (http://msdn.microsoft.com/en-us/library/ms189463.aspx) states clearly
If the query has no ORDER BY clause, the order of the rows is arbitrary.
hence putting "Ann" as the correct answer is simply wrong.
Nevertheless, using...
December 21, 2010 at 8:47 am
Adding a WHERE clause is no option for two reasons:
1) It only works for INSERT...SELECT...WHERE... statements. If INSERT...(<field list>)VALUES(<value list>) is used, the WHERE clause is not available.
2) INSERT...SELECT...WHERE... may...
December 2, 2010 at 2:33 am
Hi,
I tried by typing everything in. I can get nothing but the error message "[font="Courier New"]invalid object name 'dbo.items'[/font]". 🙁
November 28, 2010 at 1:30 am
BOL simply state
ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For...
July 5, 2010 at 12:18 pm
Paul White NZ (3/30/2010)
Dietmar Weickert (3/30/2010)
Does not work as described.Personally I do not like questions where the correctness of your answer changes with your luck.
Read the other posts here.
Still you...
March 30, 2010 at 1:13 pm
Does not work as described.
Personally I do not like questions where the correctness of your answer changes with your luck.
March 30, 2010 at 1:02 pm
Steve Jones - Editor (2/26/2010)
March 4, 2010 at 6:11 am
Once again a crap QotD.
No info about indices on the table/view to be queried? Who could potentially know about SARGable operators. And...
February 26, 2010 at 3:44 am
kaspencer (2/22/2010)
Is there a need to standardise numerical representation across every locale ?
I ask this because, in...
February 22, 2010 at 4:57 am
Hi,
We keep daily full backups for four weeks, and take log backups every 15 minutes which are stored for the current and the previous day. Everything is stored on (slightly)...
February 12, 2010 at 4:14 am
I would add to kaspencer's statement, the following addition: test, test and test again your proposed submission before submitting. Let a few days pass and retest, retest...
January 29, 2010 at 7:49 am
Hi,
I have two instances of SQL Server 2005 on the same W2K3 machine, and at least I myself never played around with the model database. (And it is unlikely someone...
January 21, 2010 at 9:01 am
Viewing 15 posts - 1 through 15 (of 42 total)