select name, ObjectType = case
when TYPE='D' then 'Default or DEFAULT constraint'
when TYPE='FN' then 'Scalar function'
when TYPE='IF' then 'Inlined table-function'
when TYPE='P' then 'Stored procedure'
when TYPE='R' then 'Rule'
when TYPE='RF' then 'Replication filter stored procedure'
when TYPE='TF' then 'Table function'
when TYPE='TR' then 'Trigger'
when TYPE='U' then 'User table'
when TYPE='V' then 'View'
when TYPE='X' then 'Extended stored procedure'
else 'others'
end
from sysobjects where id in
(select id from syscomments where text like '%'+@string+'%')
@string kısmına arama yapacağınız kelimeyi yazmalısınız.
Kaymak:
http://www.yazilimmutfagi.com/MakaleOku.aspx?Makale=SQL+Server+da+Function+KullanImI&MakaleKey=22bf9873-e46c-4716-91a0-d9b2926fa7c1
Hiç yorum yok:
Yorum Gönder