fjtello / SQL-C-sharp

Common programming and coding tips and howtos
0 stars 0 forks source link

SQL systax [#sys.sql_modules #sys.objects query stored procedure content] #18

Open fjtello opened 7 years ago

fjtello commented 7 years ago

select top 100 o.object_id, o.name SP, o.create_date, convert(varchar(max), m.definition) definicion from sys.objects o left join sys.sql_modules m on (m.object_id = o.object_id) where type = 'P' and m.definition like '%alertaase%' order by 1