Forum Replies Created

Viewing 15 posts - 616 through 630 (of 825 total)

  • RE: Table variable vs temp table

    tommyh (10/3/2011)

    There are several problems with this question. One being that you cant declare @Start 2 times.

    The other being that the answer is wrong. They both perform equally. I have...

    October 3, 2011 at 2:42 am

    #1389343

  • RE: Union results

    Very simple. Thanks. 🙂

    September 22, 2011 at 1:21 am

    #1384963

  • RE: Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke

    shayk (9/22/2011)

    Nice, but the SP unnecessary. You can write in the SSMS "Select TOP 50 * FROM "

    I also use this "Select TOP 50 * FROM ". It is better...

    September 22, 2011 at 1:17 am

    #1384961

  • RE: Unary & Aliases

    Olga B (9/13/2011)

    Ah yes, my "favorite" bit of SQL syntax

    select 0 [A]

    A fun bug to find when I accidentally delete a comma and then try to figure out what's...

    September 14, 2011 at 1:56 am

    #1381097

  • RE: Unary & Aliases

    Tom.Thomson (9/13/2011)

    Amusing and fairly easy question.

    The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third...

    September 14, 2011 at 1:41 am

    #1381092

  • RE: INSERT INTO

    Unfortunately, the editor to contribute with a question, sometime, changes the text both in the question and more often in the explanation. Yesterday, the explanation of "Unary & Aliases" was...

    September 14, 2011 at 1:37 am

    #1381091

  • RE: Order By Clause

    I immediately get it right, because I often fall in these kind of errors.

    September 6, 2011 at 1:07 am

    #1377191

  • RE: Inserted Identity

    INSERTED pulls from what is entered into table, not from the select list.

    Of course!

    August 26, 2011 at 12:47 am

    #1373589

  • RE: Exists

    OCTom (8/3/2011)

    ronmoses (8/3/2011)

    Carlo Romagnano (8/3/2011)

    EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but...

    August 3, 2011 at 6:35 am

    #1362980

  • RE: Exists

    paul s-306273 (8/3/2011)

    DugyC (8/3/2011)

    Interesting question, and something definitely to be aware of.

    Thanks

    I'm not convinved that I need to be aware of this.

    Interesting question though.

    I agree with you.

    August 3, 2011 at 3:13 am

    #1362874

  • RE: Exists

    EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but ONE ROW exists.

    August 3, 2011 at 2:44 am

    #1362861

  • RE: How to use temporary table in function

    I like dirty "solutions". In extreme cases, I know that a way exists. 😀

    July 21, 2011 at 12:55 am

    #1356164

  • RE: That case filter

    I would replace the question "How many rows returned by executing all of the following?" in "How many rows returned by the last SELECT?" and add another answer: "None, because...

    July 20, 2011 at 2:49 am

    #1355425

  • RE: That case filter

    But if that is not the case then the answer should be "There is NO query returning rows."

    I agree with you!

    July 20, 2011 at 1:33 am

    #1355397

  • RE: SELECT and WHERE without FROM

    Toreador (6/24/2011)

    I wonder which of the following (if either) is more efficient:

    select @a = 1 where @b = 0

    or

    if @b = 0 set @a = 1

    The best one seems to...

    June 24, 2011 at 9:52 am

    #1343766

Viewing 15 posts - 616 through 630 (of 825 total)