weblogs.sqlteam.com/brettk/2006/09/22/12454

Preview meta tags from the weblogs.sqlteam.com website.

Linked Hostnames

2

Search Engine Appearance

Google

https://weblogs.sqlteam.com/brettk/2006/09/22/12454

How do I find all the tables referenced by Stored Procedures or Functions

Like this SELECT o.name, t.TABLE_NAME, c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id JOIN INFORMATION_SCHEMA.Tables t ON c.text LIKE '%'+t.TABLE_NAME+'%'   Legacy Comments Peter DeBetta, Microsoft MVP - S 2006-09-22 re: How do I find all the tables referenced by Stored Procedures or Functions Actually, that isn't entirely reliable if the code of the procedure is longer than 8000 characters.



Bing

How do I find all the tables referenced by Stored Procedures or Functions

https://weblogs.sqlteam.com/brettk/2006/09/22/12454

Like this SELECT o.name, t.TABLE_NAME, c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id JOIN INFORMATION_SCHEMA.Tables t ON c.text LIKE '%'+t.TABLE_NAME+'%'   Legacy Comments Peter DeBetta, Microsoft MVP - S 2006-09-22 re: How do I find all the tables referenced by Stored Procedures or Functions Actually, that isn't entirely reliable if the code of the procedure is longer than 8000 characters.



DuckDuckGo

https://weblogs.sqlteam.com/brettk/2006/09/22/12454

How do I find all the tables referenced by Stored Procedures or Functions

Like this SELECT o.name, t.TABLE_NAME, c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id JOIN INFORMATION_SCHEMA.Tables t ON c.text LIKE '%'+t.TABLE_NAME+'%'   Legacy Comments Peter DeBetta, Microsoft MVP - S 2006-09-22 re: How do I find all the tables referenced by Stored Procedures or Functions Actually, that isn't entirely reliable if the code of the procedure is longer than 8000 characters.

  • General Meta Tags

    6
    • title
      How do I find all the tables referenced by Stored Procedures or Functions | Brett Kaiser (x002548) Blog
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1, shrink-to-fit=no
    • article:published_time
      2006-09-22T12:32:54-05:00
    • article:modified_time
      2006-09-22T12:32:54-05:00

  • Open Graph Meta Tags

    4
    • og:title
      How do I find all the tables referenced by Stored Procedures or Functions
    • og:description
      Like this SELECT o.name, t.TABLE_NAME, c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id JOIN INFORMATION_SCHEMA.Tables t ON c.text LIKE '%'+t.TABLE_NAME+'%'   Legacy Comments Peter DeBetta, Microsoft MVP - S 2006-09-22 re: How do I find all the tables referenced by Stored Procedures or Functions Actually, that isn't entirely reliable if the code of the procedure is longer than 8000 characters.
    • og:type
      article
    • og:url
      https://weblogs.sqlteam.com/brettk/2006/09/22/12454/

  • Twitter Meta Tags

    3
    • twitter:card
      summary
    • twitter:title
      How do I find all the tables referenced by Stored Procedures or Functions
    • twitter:description
      Like this SELECT o.name, t.TABLE_NAME, c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id JOIN INFORMATION_SCHEMA.Tables t ON c.text LIKE '%'+t.TABLE_NAME+'%'   Legacy Comments Peter DeBetta, Microsoft MVP - S 2006-09-22 re: How do I find all the tables referenced by Stored Procedures or Functions Actually, that isn't entirely reliable if the code of the procedure is longer than 8000 characters.

  • Link Tags

    2
    • canonical
      https://weblogs.sqlteam.com/brettk/2006/09/22/12454/
    • stylesheet
      https://weblogs.sqlteam.com/brettk/css/style.css

Links

4