Viewing 15 posts - 436 through 450 (of 454 total)
Chirag (9/3/2009)
I found the question confusing. It asks for value of @@Error which is 15248. I put the statement in a TRY/CATCH and got the @@Error as 15248.
The question is...
September 3, 2009 at 6:02 am
Good article. I have a 3rd party app which will begin using the FILESTREAM attribute in the next major release, and this article gives me a good overview of how...
August 28, 2009 at 6:45 am
Why not just do (using the function definition and parameters (and the @firstDate variable) as given):
set @firstDate = dateadd(dd,1-datepart(dd,@inputdate) ,@inputDate) -- ensures that we start with the first of the...
August 21, 2009 at 11:52 am
Jim in Arizona (8/20/2009)
I think the 30% of us (me included) that got it wrong just need to make sure we get our morning caffiene before trying to answer the...
August 20, 2009 at 10:45 am
Mark Horninger (7/14/2008)
Bill Whitman (7/14/2008)
oberhardt is correct.A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Probably don't want to...
August 7, 2009 at 7:32 am
The <strong> tags are clearly an issue with the CMS here; I've seen it in a few other code samples. I don't know if the preview works with them where...
July 29, 2009 at 7:36 am
Carlo Romagnano (7/23/2009)
Lynn Pettis (7/23/2009)
There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?
For example you...
July 23, 2009 at 11:19 am
Interestingly enough, the MSDN documentation linked to from the answer incorrectly states:
"In this case, the number of characters that are returned is the largest value of either the sum of...
July 10, 2009 at 11:01 am
I think it comes down to personality. I find two classes of personalities in this business: those that overgeneralize, and those that don't. 😛
Okay, seriously, the personality trait I look...
June 19, 2009 at 8:36 am
I think this was a very useful article, because it highlighted a difference we sometimes forget between T-SQL and procedural code. Specifically, procedural code like
set value1 = value2
set value2 =...
May 27, 2009 at 8:34 am
I can definitely see some use for this.
Even if I had no use for it at all, it's a very interesting academic exercise. I'm looking forward to seeing how you...
May 11, 2009 at 11:03 am
Here's how I see the difference. It may help you to understand the order of execution, or it may just confuse you, but it's how I read the statements semantically....
May 7, 2009 at 11:46 am
Sylvia is actually right when she says that there's no need for aliases in author-title query. But Jeff is right when he says that code is not written well for...
May 7, 2009 at 8:54 am
jwheeler (4/27/2009)
Samuel Vella (4/27/2009)
jwheeler (4/27/2009)
The fact you even have to tell so called developers this stuff is frightening.
Not really and it's something I've seen a few times...
When someone has...
April 27, 2009 at 8:07 am
Viewing 15 posts - 436 through 450 (of 454 total)