none
What am i missing? RRS feed

Answers

  • Access to data in a correct way is

     SELECT [SCHEMA].[Table].[Columns]

    Access to data in a correct way
    that is
    SELECT [dbo]. [ProductListing] .Item


    Wesley Neves

    • Marked as answer by runway500 Friday, November 25, 2016 7:49 PM
    Friday, November 25, 2016 7:32 PM
  • Hello,

    It's not enough to address only the column name, you have to add the table name in the FROM clause to let SQL Server know from where you want to query the data =>

    SELECT Item
    FROM dbo.ProductListing


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by runway500 Friday, November 25, 2016 7:49 PM
    Friday, November 25, 2016 7:39 PM

All replies

  • Access to data in a correct way is

     SELECT [SCHEMA].[Table].[Columns]

    Access to data in a correct way
    that is
    SELECT [dbo]. [ProductListing] .Item


    Wesley Neves

    • Marked as answer by runway500 Friday, November 25, 2016 7:49 PM
    Friday, November 25, 2016 7:32 PM
  • This returned when i tried that "The multi-part identifier "dbo.ProductListing.Item" could not be bound.""
    • Marked as answer by runway500 Friday, November 25, 2016 7:49 PM
    • Unmarked as answer by runway500 Friday, November 25, 2016 7:49 PM
    Friday, November 25, 2016 7:38 PM
  • Hello,

    It's not enough to address only the column name, you have to add the table name in the FROM clause to let SQL Server know from where you want to query the data =>

    SELECT Item
    FROM dbo.ProductListing


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by runway500 Friday, November 25, 2016 7:49 PM
    Friday, November 25, 2016 7:39 PM
  • Thanks you guys!
    Friday, November 25, 2016 7:49 PM