SQL Server OpenRowSet on Unknown Table

  • Thread starter Thread starter Pepper Mint
  • Start date Start date
  • Tags Tags
    Server Sql Table
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
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