Prev: Want to modify this procedure to have a range of periods rather than a single period
Next: question about replace function
From: Roy Goldhammer on 11 Jul 2010 04:11
In sql server 2005 microsoft added system views to almost all the objects in
system exept functions.

is it true?


From: Jeroen Mostert on 11 Jul 2010 04:29
On 2010-07-11 10:11, Roy Goldhammer wrote:
> In sql server 2005 microsoft added system views to almost all the objects in
> system exept functions.
>
> is it true?
>
Depends on what sort of views you're expecting. There is no sys.functions,
but you can definitely find them in system views.

select * from sys.objects join sys.sql_modules on objects.object_id =
sql_modules.object_id where objects.type in ('fn', 'if', 'tf')

--
J.
 | 
Pages: 1
Prev: Want to modify this procedure to have a range of periods rather than a single period
Next: question about replace function