Forum Replies Created

Viewing 15 posts - 1 through 15 (of 38 total)

  • RE: U-SQL data types

    I'm inclined to agree with you, but I asked the question because ARRAY is in the ANSI SQL standard.
    The following quote comes from SQL:1999 , formerly known as SQL3...

  • RE: U-SQL data types

    Will ARRAY ever be added to T-SQL?
    Who would like to see it added?

  • RE: Beginning a CTE

    Terje Hermanseter (6/3/2016)

    I don't understand why MS is wavering on the commitment to enforce them as they've been part of the ISO-1999 standard for a very long time.

    Too much old...

  • RE: Beginning a CTE

    Anyone who doesn't terminate SQL statements with a semicolon should note the following (from ):

    Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version of...

  • RE: Executing as my own context

    Yes, "really dangerous".

    I can't imagine any situation where it would be good practice to do this (although I understand how it could be tempting).

    Does anyone have an example of where...

  • RE: A Scary Day

    Looks like a third of people should have stayed in bed with the covers over their heads rather than answer this question... :w00t:

  • RE: Getting index columns

    Had to think hard about that one ...

  • RE: The dotted table

    According to Chambers Dictionary, the definition of "wrong" includes:

    "not appropriate or suitable"

    "not good or sensible; unjustifiable"

    "amiss, causing trouble, pain, etc"

    "not socially acceptable"

    I think you could make a case for the...

  • RE: The TOP 10 Count

    Of course, if you have more than 2^21 columns in your database, it will return an error ... 😀

  • RE: Counting the Tally Table

    What version of SQL Server Management Studio are you using, Daleen?

    Inserting multiple value lists is only possible from SQL Server 2008 onwards, so if you are running SQL Server 2005...

  • RE: Happy Monday

    For amusement, you could try the following:

    select convert(smalldatetime,'9-2014-1',110)

    This returns 1st Sept 2014.

    It appears that it doesn't matter where in the string you put the year!

  • RE: Datatypes In Your Mind

    pmadhavapeddi22 (5/7/2014)

    As per my observation, below mentioned code returns error ,

    DECLARE @int AS INT = @b1 + @b2;

    SELECT @b1 + @b2;

    but, following code returns 5

    DECLARE @b1...

  • RE: Datatypes In Your Mind

    Eirikur Eiriksson (5/6/2014)

    I think Andy has been a tiny bit naughty:-D

    Is a "tiny bit" a "bit" that will only store zeroes? 😀

    My personal feeling is that "bit" is not an...

  • RE: Character Field Declaration

    Koen Verbeeck (2/11/2014)

    ashwani24 (2/10/2014)

    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any...

  • RE: Character Field Declaration

    Stuart Davies (2/11/2014)

    Nice question

    Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

    Here in the north...

Viewing 15 posts - 1 through 15 (of 38 total)