Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: The Potential of Joins

    Scenario 2 doesn't have a NOT IN in the original statement...I believe it belongs here:

    select DISTINCT Name

    from Production.Product

    where ProductID IN (Select ProductID from Purchasing.ProductVendor

    ...

  • RE: Clustered Index Internals

    Glad to hear the system thinks for its authors...LOL

  • RE: Clustered Index Internals

    OK, so I didn't think the second statement was true, and apparantly it is...

    That isn't my problem with the question, my problem is (as stated before) authors don't know how...

  • RE: Varchar or Char?

    We need to define a column that will contain externally provided identifiers. Their

    (1) length will vary from seven to ten characters

    (2) all English letters

    (3) both upper and lower case...

  • RE: B-tree

    In computer science, a B-tree is a tree data structure that keeps data sorted and allows searches, insertions, deletions, and sequential access in logarithmic amortized time. The B-tree is a...

  • RE: @@DBTS

    http://msdn.microsoft.com/en-us/library/ms187366.aspx

    SQL Server 2008 Books Online (August 2009)

    @@DBTS (Transact-SQL)

    "Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in...

  • RE: UPDATE

    I too answered 'no' based upon the example...perhaps the example shouldn't have been given and just the question asked, but if you ran the given statement, it would certainly fail...

  • RE: cast, convert and float!

    That is good to know the next time I want to:

    A.) Convert an interger to a varchar then

    B.) Convert that varchar to a smaller varchar then

    C.) Cast...

  • RE: Weird datetime conversions

    None of the Above???

    I received this as my results:

    1899-12-31 00:00:00.000

    Did the question change over time, too?

  • RE: one character of data

    if you have ever worked with localization, the answer is clearly nchar(1)...

  • RE: DTEXEC thorws error saying Argument "Excel" for option "connection" is not valid.

    We were unable to get any of these remedies to work. What we ended up doing (on a 64-bit Server - may have been the Jet Driver problem to...

Viewing 11 posts - 1 through 11 (of 11 total)