Select system function names in SQL Server

Question

I have a table with a bunch of queries.

What I have to do is selecting records which has query using SQL Server system function.

It would be the best to select all system function names so that I can get it done with the subquery within a where clause.

The advice would be great.

4b0 · Accepted Answer · 2011-11-16 05:43:46Z

0

We recommended that you use the system functions, Information Schema Views, or the system stored procedures to obtain system information without directly querying the system tables.
Source:
http://msdn.microsoft.com/en-us/library/ms191238%28v=sql.90%29.aspx

answered Nov 16, 2011 at 5:43

4b0

22.4k30 gold badges97 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1