— Applicable for SQL 2005 and later versions USE [Your_DB]; SELECT [Scehma] = schema_name(o.schema_id), o.Name, o.type FROM sys.sql_modules m INNER JOIN sys.objects o ON o.object_id = m.object_id WHERE m.definition like ‘%your_text_to_search%’
Tag: search
How to remove searching, filtering, ordering and info from Asp.NET MVC Datatable
var table = $(“#datatable”).DataTable({ “paging”: false, “ordering”: false, “searching”: false, “info”: false });
Search text through Divs in Javascript
<table align=”center” width=”20%”> <tr> <td style=”padding-right: 10px”> <input type=”text” id=”Search” onkeyup=”myFunction()” placeholder=”Please enter a search term..” title=”Type in a name”> </td> </tr> </table> <br> <div class=”target”> This is my DIV element. </div> <div class=”target”> This is another Div element. </div> <div class=”target”> Can you find me? </div> <script> function myFunction() { var input = document.getElementById(“Search”); […]
How to fix Windows 10 can’t type in search bar
Usually, the issue is caused because your Language bar is turned off. Ctfmon.exe is the file responsible for controlling this feature. So, running the ctfmon.exe file resolves the issue. Hold Windows key and press R Type C:\Windows\system32\ctfmon.exe and press Enter
How to use column search in datatable when responsive is false
just add “$(“th”).show();” in the end of initComplete … , initComplete: function () { … $(“th”).show(); } , …
Search text in all tables in SQL Server
Please note that with a little bit changing you can also use this query as a stored procedure.
Search text in all stored procedures in SQL Server
SELECT name FROM sys.procedures WHERE Object_definition(object_id) LIKE ‘%search_parameter%’