Forum Replies Created

Viewing 15 posts - 76 through 90 (of 163 total)

  • RE: Datatypes In Your Mind

    The list shown here includes bit in the list of "exact numeric types".

    http://msdn.microsoft.com/en-us/library/ms187752.aspx (Data Types (Transact-SQL))

    Besides this reference page (including the ones for other version of SQL), I...

    May 6, 2014 at 6:40 am

    #1711025

  • RE: It's Not All About The Keys

    nenad-zivkovic (4/14/2014)

    The logic behind the question suggest that the `backuplist` is subset of `databases`, and that FK should be created on `backuplist` to reference `databases`. Check query seems to support...

    April 14, 2014 at 2:52 am

    #1705668

  • RE: A Questionable Trigger

    Andy, can you display the results that you get, including your error and can you tell which tool and version you are using to execute the statements?

    As I said before,...

    April 2, 2014 at 4:27 am

    #1702384

  • RE: A Questionable Trigger

    Carlo Romagnano (4/2/2014)

    In sqlserver 2008 r2 the update doesn't return any resultset and no error message.

    (2 row(s) affected)

    (2 row(s) affected)

    What I'm missing?

    You are missing nothing. The update works fine and...

    April 2, 2014 at 3:03 am

    #1702357

  • RE: Can't See The Forest For the Logins

    I don't agree on the "correct answer". According to me the only correct combination of options can be option 1 and 2.

    Nowhere it has been said that the AdventureWorks2012 database...

    March 28, 2014 at 2:46 am

    #1701007

  • RE: The Model Database

    James Lean (2/18/2014)

    Actually, MSDN is NOT wrong. You cannot make the primary filegroup read-only. This is actually a restriction on ANY database.

    You can make the whole database read-only...

    February 18, 2014 at 7:15 am

    #1689889

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    Also, the question should specify this is SQL2012 specific (alter server role).

    I wonder how many people gave an "incorrect" answer, based on the fact that they were not using SQL2012,...

    January 23, 2014 at 7:16 am

    #1682765

  • RE: HASHBYTES

    Interesting question, however, I don't understand why the "LEFT JOIN"-construction was used.

    Distracts a little bit from what was the essential part of the question.

    January 21, 2014 at 3:08 am

    #1681790

  • RE: Windowing Ranges

    Maybe worthwhile to mention that this functionality was introduced in SQL Server 2012.

    December 9, 2013 at 4:37 am

    #1671880

  • RE: Order My Data

    Guess that all has been said before. Only the "order by" answer is correct.

    Agree with some others to delete this question, before people might get a wrong idea.

    December 2, 2013 at 7:03 am

    #1670109

  • RE: REGEX

    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    November 14, 2013 at 2:19 am

    #1666290

  • RE: Using Max()

    paul.knibbs (11/8/2013)

    I kind of agree with waxingsatirical...it never occurred to me anyone would think this works otherwise, and I spent a good few minutes trying to figure out what unexpected...

    November 8, 2013 at 6:48 am

    #1665089

  • RE: Using a column name in a COUNT function

    paul s-306273 (10/15/2013)

    Who'd have thought count(*) would generate so much debate...

    I agree, and that apparently nobody uses a where clause while counting, but that they only are interested in all...

    October 15, 2013 at 8:14 am

    #1658547

  • RE: Using a column name in a COUNT function

    ...This can produce some surprising results. This is because of the way that COUNT() works...

    Why the surprise if COUNT exactly does what is described in e.g. Technet?

    October 15, 2013 at 7:01 am

    #1658503

  • RE: Field Lengths

    Simple question, but wonder why the question was not just focused on column d and e and DATALENGTH and LEN.

    October 11, 2013 at 1:10 am

    #1657807

Viewing 15 posts - 76 through 90 (of 163 total)