locked
BUG:(?)"Transact SQL & pop-up objects list." RRS feed

  • Question

  • Hello everybody. When I start to test SQL 2008 Febuary CTP I detect that sume of new  options work incorrectly. This is description of this bug from Microsoft Connect:"I don`t know, may be somebody detect this issue too. Sorry If I create duplicate. I start SQL Server Managment Studio & click new query. After that I try to create simple query like this
    Uses Master
    Select "column name" from "table".
    I was surprised because when start write column name I saw the pop-up objects list. But this was very strange list, because I didn`t find necessary columns. This list show only "common" objects(such as database nemes, functions & ect). I think that such list(after first select) should show only children objects(columns, keys, triggers, indexes & ect.), after that is you write "from" such list should show only parents objects (Such as table name, database name & ect).
    PS. Sorry for my english." After that(today) I get the answer from MS SQL Team "Hi,

    Your observation is correct. Selection list (column names) can suggests correct candidates once user specifies FROM clause.

    Regrads,
    Eric Kang
    SQL Server Program Manager" & bug was closed as "By Design". Then I reopen this bug with such comments "

    But It`s lokks very strange. If I want to select column name from the list I should: 1. write SELECT 2. Press Space 2. Write FROM "Table name" 3. Returt to free space after SELECT 4. Start Write "Column name". 5. Choose the necessary Column name from the list. There are too much for such simple operation.
    Posted by stanisluv on 3/19/2008 at 11:45 AM
    Too much steps.
    " Sorry I make a typo. I mean: "looks". If anybody else argee with me please validate & vote the feedback. This is the link for it: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=333047
    Wednesday, March 19, 2008 7:02 PM

All replies

  • I post the feedback information because everybody(guests too) can see this feedback.

    Wednesday, March 19, 2008 7:14 PM