CODEWITHSUNDEEP
sql-server
KIM
KIM

Reputation: 1254

Select system function names in SQL Server

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.

Upvotes: 0

Views: 460

Answers (1)

4b0
4b0

Reputation: 22323

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

Upvotes: 0

Related Questions