PaulRobertson14

Tuesday, 9 April 2013

Search Schema for Text (eg. column names)

SELECT DISTINCT OBJECT_NAME(id) AS ObjectName
FROM syscomments WHERE [text] LIKE '%business_day%'
ORDER BY 1
Posted by Unknown at 12:29
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Server, T-SQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2013 (10)
    • ►  June (1)
    • ▼  April (9)
      • SSAS Cube Calculations (YTD, BTD, PY, PYTD)
      • Collation Conflict between databases (tempdb and u...
      • CUBEVALUE() and CUBEMEMBER() and CUBESET(), oh my!
      • SQL Server System Information returned by SERVERPR...
      • Row Counts for All Tables in a Database
      • Search Schema for Text (eg. column names)
      • Select Date Formats Using CONVERT() Function
      • Concatenate Using FOR XML
      • List of Month Names Using CTE

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.