Forum Replies Created

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

  • RE: Using Regular expression to convert PL/SQL code to TSQL

    venus.pvr (10/10/2011)

    Comments posted to this topic are about the item <A HREF="/articles/Regular+Expressions/75121/">Using Regular expression to convert PL/SQL code to TSQL</A>

    Thanks! I found it very interesting for Regular expression syntax.

    October 11, 2011 at 12:55 am

    #1392677

  • RE: Elementary Key Attributes

    I get it wrong, but I like this kind of questions.

    Thanks.

    October 5, 2011 at 1:19 am

    #1390519

  • 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

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