Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sql to search database objects' definitions for text
--Title of this code --Batches are separated by 'go' CREATE Function [dbo].[TestFunction]() Returns int AS Begin declare @res int select @res=count(*) from Pilots Return @res End GO --find objects which contain 'Pilots' in defintion DECLARE @Search varchar(255) SET @Search='Pilots' SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like '%'+@Search+'%' ORDER BY 2,1
run
|
edit
|
history
|
help
0
SQL injection
SCHOOL-BUILD
sql jueves
Time packing with joins
Program1
practice sql_12AUG
Función Borrar carácter inicial repetido
Insert multiple parent-child records
FIGURA5.1
DGDFGDFG