Forum Replies Created

Viewing 15 posts - 106 through 120 (of 521 total)

  • RE: Automated Trigger To Require a WHERE Clause

    HowardW (1/25/2011)

    Oracle's query tools (Oracle SQL Developer and SQLPlus) by default require you to explicitly commit regardless of whether you explicitly began a transaction.

    Well, SQL Plus is a little awkward...

    January 25, 2011 at 6:39 am

    #1277795

  • RE: CONVERT function

    Koen (da-zero) (1/13/2011)

    Great, but difficult question.

    I had to read the section on converting binary string data on the MSDN page for CAST and CONVERT a few times to get it.

    But...

    January 13, 2011 at 1:06 am

    #1272840

  • RE: ANSI Padding

    Richard Sisk (1/11/2011)

    Would have got it right except I was thrown by the apparent conflict that the question was for SQL Server 2008 but the last option clearly asks about...

    January 11, 2011 at 9:31 am

    #1271944

  • RE: ANSI Padding

    Toreador (1/11/2011)

    As for the option about performance relative to SQL2000 - that's an 11-year-old unsupported version[...]

    SQL Server 2000 is not unsupported. Only the mainstream support has ended.

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2008/02/15/end-of-mainstream-support-for-sql-server-2005-sp1-and-sql-server-2000-sp4.aspx

    January 11, 2011 at 2:31 am

    #1271763

  • RE: ANSI Padding

    Hi,

    I almost got the question right, but failed because of the usage of index on computed columns.

    I have tested it with the following script and the index seems to be...

    January 11, 2011 at 1:40 am

    #1271750

  • RE: T-sql

    I like the question, mostly because it focuses on one aspect only - the default size.

    Too many times there are complicated questions which mix the question itself with ostacles and...

    December 21, 2010 at 2:12 am

    #1264946

  • RE: Nested Temporary Tables

    I think the question is very good as well, but I am not sure if the answer is correct.

    I chose

    Error: "Column name or number of supplied values does not...

    December 16, 2010 at 1:42 am

    #1263328

  • RE: T-SQL

    Good Question, but not valid for all languages, since some have different date formats (ymd):

    Japanese

    Swedish

    Hungarian

    Croatian

    Latvian

    Lithuanian

    Traditional Chinese

    Korean

    Simplified Chinese

    SELECT dateformat, name, alias FROM sys.syslanguages WHERE dateformat NOT LIKE '%y'

    December 15, 2010 at 2:19 am

    #1262693

  • RE: Unique constraint on a nullable column

    jeff.mason (12/2/2010)

    sjimmo (12/2/2010)

    But once you give out INSERT permission, you lose control over INSERT statements.

    It is not only that. Constraints should prevent invalid data updates no matter where they come...

    December 2, 2010 at 8:00 am

    #1257903

  • RE: Unique constraint on a nullable column

    Hm, this is a very good topic, and most answers make sense.

    But the last one with the where clause for all inserts is nonsense. You cannot "enforce" uniqueness by...

    December 2, 2010 at 1:22 am

    #1257745

  • RE: sys.syscomments

    Tom.Thomson (12/1/2010)

    If you've never seen any comments in there I don't want you writing any stored procedures or triggers in my shop!

    You may have missed my 3rd post where I...

    December 1, 2010 at 6:03 am

    #1257275

  • RE: sys.syscomments

    Ok, I think I finally arrived.

    I thought the "comments" were the standalone extended properties / description of the stored procedures, constraints etc..

    I did not consider the inline comments of the...

    December 1, 2010 at 1:16 am

    #1257190

  • RE: sys.syscomments

    Carlo Romagnano (12/1/2010)

    I disagree: the query returns all rows that contains the word 'order' in the column [text] that may appear in comments or definition.

    I think the wording "consists" was...

    December 1, 2010 at 1:05 am

    #1257185

  • RE: sys.syscomments

    Nils Gustav Stråbø (12/1/2010)

    Both the definition and the comments can be retrieved from sys.syscomments view

    Are you sure about that? I can't see any comments in that view.

    With regards to option...

    December 1, 2010 at 12:59 am

    #1257183

  • RE: Predict the total count

    No comment, next question... 🙂

    November 5, 2010 at 2:31 am

    #1247009

Viewing 15 posts - 106 through 120 (of 521 total)