Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 3,348 total)

  • RE: Working on stored procedures

    mandeep_nyc (8/27/2012)

    if you run the script as it is, it will fail because a GO is requried.

    That's why the question text explicitly says: "If I execute both scripts separately". You...

    August 27, 2012 at 7:42 am

    #1530346

  • RE: Working on stored procedures

    (Bob Brown) (8/27/2012)

    Hugo Kornelis (8/27/2012)

    After reading this, I tested it for myself on my SQL 2012. I ensured no table named table1 or table2 exists, then executed this...

    August 27, 2012 at 4:55 am

    #1530284

  • RE: Working on stored procedures

    sam.dahl (8/26/2012)

    Firstly, "I have two stored procedures" suggested to me that the scripts we were executing were the actual stored procedures not necessarily the create scripts depicted.

    This may well be...

    August 27, 2012 at 3:34 am

    #1530256

  • RE: Inserts

    mtassin (8/23/2012)

    So what purpose did leaving out the table create statements or saying that we have to assume that they exist in the text prior to the code serve?

    I don't...

    August 23, 2012 at 10:04 am

    #1529354

  • RE: Inserts

    mtassin (8/23/2012)

    *sigh* I guess we'll just disagree here

    Hmmm, I'd rather say that you are agreeing vehemently!

    sknox writes: >>You happened to get it right because you didn't read that error message...

    August 23, 2012 at 9:36 am

    #1529334

  • RE: Inserts

    Steve Jones - SSC Editor (8/23/2012)

    I'll disagree with you and agree with sknox.

    If you thought that you could do an insert into @x without defining @x, you would learn something...

    August 23, 2012 at 8:55 am

    #1529305

  • RE: concatenation

    A good question. I'll admit that I am surprised at the high number of incorrect answers; I would have expected 70 to 80 percent to get this right.

    I'm not surprised...

    August 21, 2012 at 4:06 am

    #1528014

  • RE: Basic of T-SQL

    sknox (8/20/2012)

    Interesting. One could argue that this is a bug in SQL server, since cast('a' as int) logically cannot exist...

    On one hand, I tend to agree with you. On the...

    August 20, 2012 at 10:26 am

    #1527726

  • RE: Basic of T-SQL

    EL Jerry (8/20/2012)

    I was told once before (by an Oracle DBA) that using COUNT(*) was not a recommended practice as it would cause performance issues because the database engine would...

    August 20, 2012 at 8:51 am

    #1527656

  • RE: T-SQL Syntax

    I appreciate the amount of research that went into this question and I think it has a good educational value, but I don't think a QotD is the right form...

    August 17, 2012 at 3:23 am

    #1526976

  • RE: Table Variable

    sestell1 (8/16/2012)

    A good question. This is a drawback to using table variables for temporary storage that you need to remember to work around.

    Actually, this is not a drawback and...

    August 16, 2012 at 6:53 am

    #1526535

  • RE: NULL

    honza.mf (8/16/2012)

    Hugo Kornelis (8/16/2012)

    honza.mf (8/15/2012)

    Lokesh Vij (8/14/2012)

    rVadim (8/14/2012)

    I think any comparison against NULL will yield Unknown, which is not True, and therefore records won't be returned.

    +1

    Yes that's correct!

    +1

    And even...

    August 16, 2012 at 4:46 am

    #1526460

  • RE: NULL

    honza.mf (8/15/2012)

    Lokesh Vij (8/14/2012)

    rVadim (8/14/2012)

    I think any comparison against NULL will yield Unknown, which is not True, and therefore records won't be returned.

    +1

    Yes that's correct!

    +1

    And even worse the answer...

    August 16, 2012 at 2:38 am

    #1526393

  • RE: BIT Conversions

    buntyteg (8/14/2012)

    means to say... in bit datatype how we can store 25 (2 digit) value

    No. Any value other than 0 is converted to 1. So 1 is stored as given,...

    August 14, 2012 at 12:40 pm

    #1525735

  • RE: BIT Conversions

    WayneS (8/14/2012)

    One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not...

    August 14, 2012 at 7:48 am

    #1525526

Viewing 15 posts - 2,041 through 2,055 (of 3,348 total)