Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

SQL Server OpenRowSet on Unknown Table

  1. Aug 2, 2016 #1
    Code (SQL):
    SELECT c.object_id AS id,
            CONVERT(SMALLINT, c.column_id) AS NUMBER,
           s.colid, s.STATUS,
            CONVERT(varbinary(8000), s.text) AS ctext,
            CONVERT(SMALLINT, 2 + 4 * (s.STATUS & 1)) AS texttype,
        FROM sys.computed_columns c CROSS APPLY OPENROWSET(TABLE SQLSRC, c.object_id, c.column_id) s
    Would someone please help me explain what TABLE SQLSRC in the code means ? I am splitting hairs to just get a glimpse of it but still unable to figure it out.
    Last edited by a moderator: Aug 3, 2016
  2. jcsd
  3. Aug 3, 2016 #2


    Staff: Mentor

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted