Forum Replies Created

Viewing 11 posts - 646 through 656 (of 656 total)

  • RE: one character of data

    Christian Buettner (6/8/2009)


    Toreador (6/8/2009)


    The best type cannot be one which will not work for a large subset of possible characters (ie any Unicode character)

    Why?

    Because if the spec says you need...

  • RE: one character of data

    The question asks for the 'best' type for storing a character. The best type cannot be one which will not work for a large subset of possible characters (ie any...

  • RE: nvarchar

    Richard Driscoll (5/28/2009)


    oh come on! How does N-Var-Char translate to this answer!

    Ask the people who created the ISO standards, as that's where it comes from!

  • RE: Rename objects

    One 'gotcha' is that if you rename a stored procedure, the code returned by sp_helptext will still have the original name 🙂

  • RE: Queries with Aggregate Functions

    Mahesh Bote (5/27/2009)


    [font="Verdana"]Answer should be 1, 2 and 4 as well as 2nd and 4th query are same.

    Mahesh[/font]

    Look more carefully - the second query is 'GROUP BY ManagerID' and will...

  • RE: Create Database

    Lynn Pettis (5/13/2009)


    If you take a few minutes to read CREATE DATABASE in BOL you'd see that it is required that the directory structure already be in place, therefore for...

  • RE: Create Database

    Rachel Byford (5/13/2009)


    I don't, however, have much patience once the same observation has been made over and over again!

    Everybody should read the entire discussion before they decide to post to...

  • RE: Create Database

    Steve Jones - Editor (5/11/2009)


    If you see a path, you need to assume that path exists on the test system.

    Why? The question could be about whether or not SQLServer...

  • RE: Create Database

    Msg 5133, Level 16, State 1, Line 1

    Directory lookup for the file "C:\mssql\MYTEST.doc" failed with the operating system error 2(error not found).

    Msg 1802, Level 16, State 1, Line 1

    CREATE DATABASE...

  • RE: T-SQL Operators

    Lynn Pettis (4/14/2009)


    I guess not enough people complained about the answer to this question.

    I guess I'd better complain too then 😉

    MDX != TSQL

  • RE: Error Severity

    Agreed, the answer should definitely be 0 to 25 for the reasons already given

Viewing 11 posts - 646 through 656 (of 656 total)