Miguel
unread,Oct 22, 2011, 4:10:30 PM10/22/11Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Argow
Muitas vezes precisamos procurar por uma palavra em SPs ou funções.
Aqui como criar uma view para acessar os dados e realizar a pesquisa
usando “Localizar Avançado” de uma janela PAD.
Select --*,
ROUTINE_NAME As Nome
,ROUTINE_TYPE As Tipo
,IsNull( DATA_TYPE, '' ) + ( Case When CHARACTER_MAXIMUM_LENGTH is
Null Then '' Else '(' + Ltrim(Str(CHARACTER_MAXIMUM_LENGTH)) + ')'
End ) As Resultado
,ROUTINE_DEFINITION As Corpo
, CREATED As Creado
, LAST_ALtered As Modificado
From INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_NAME not like 'sp[_]%'
Order by ROUTINE_TYPE, ROUTINE_NAME
Miguel