SQL Server OpenRowSet on Unknown Table

  • Thread starter Thread starter Pepper Mint
  • Start date Start date
  • Tags Tags
    Server Sql Table
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
1 reply · 2K views
Pepper Mint
Messages
91
Reaction score
139
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,
        convert(smallint, 0) AS language,     
       s.text
    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:
Physics news on Phys.org