How do I search an SQL Server database for a string?
Dec 8, 2019 · 152 I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string …
SQL SELECT WHERE field contains words - Stack Overflow
Jan 12, 2013 · This should ideally be done with the help of SQL Server full text search if using that. However, if you can't get that working on your DB for some reason, here is a …
SQL 'LIKE' query using '%' where the search criteria contains
May 29, 2012 · I have an SQL query as below. Select * from table where name like '%' + search_criteria + '%' If search_criteria = 'abc', it will return data containing xxxabcxxxx which is …
Search text in stored procedure in SQL Server - Stack Overflow
Feb 5, 2013 · I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m …
SQL list of all the user defined functions in a database
SELECT ROUTINE_NAME FROM information_schema.routines WHERE routine_type = 'function' but I can't think of or find a way to feed the ROUTINE_NAME list to the OBJECT_ID. The …
sql - How can I search for numbers in a varchar column - Stack …
Apr 19, 2012 · Can I do a simple search in SQL to identify these cases? That is, determine which rows in the table contain only digits in this column. As an extension, could I also search for …
sql - Finding all Stored procedures calling a function - Stack …
Aug 23, 2012 · A 'low-tech' way to find all the stored procedures using a function is to use management studio to "generate scripts" for all the procs into a single file, and then use the …
Find sql records containing similar strings - Stack Overflow
If you're able to do CLR user-defined functions on your SQL Server, you can implement your own Levensthein Distance algorithm and then from there create a function that gives you a …
Find a specific substring using Transact-SQL - Stack Overflow
Jun 17, 2009 · I need to pull a specific substring from a string of the form: foo=abc;bar=def;baz=ghi For example, how would I get the value of "bar" from that string?
sql - Quickest/Easiest way to use Search/Replace through all …
20 Actually, this is a 2 part question. Is it possible to use some sort of functionality to search through every stored procedure for a string and possibly replace it, like a standard …