Custom Search
|
|
How To Browse Your Database Entities In A Whole New Way
If sql developers have an sql search tool which may be utilized to discover certain keywords in SQL Server object definitions, then the solution to search string in sql is easy. However, most sql administrators and t-sql developers don't have such a sql search tool. As the concept of search continues to grow in scope, I tend to find myself eschewing numerous levels of categorization in favor of larger groups. I'll give you two examples of what I mean. Believe of your inbox. I used to have folders for various systems, folders for different clients, folders for distinct colleagues, and so on. Now I tend to leave everything in my inbox and use the various search functions of my mail client or other search applications to retrieve messages as I need them. I'm not positive if this is due to the reality that the searching capabilities of these applications are far better than they employed to be or if I'm just more prone to looking for points given that that is what all the hip children are performing nowadays. Think of a data driven web web site. A retail website possibly. As you drill down into the categories of goods, you will usually have a breadcrumb trail somewhere on the page. Do we actually drill that far down these days or do we right away go to the search box and kind in what we're searching for? If it is the latter case, what's the point of having a bunch of piddly little categories like Electronics > Digital Cameras > Memory Cards > 512MB? Why not just dump every thing in 1 huge category and let the search functionality take care of the method of discovering something? I like to have the ability to find some thing on the fly when required and I don't need to have to bear in mind how I originally categorized it. What's the login info for that FTP web site? Categorization is tedious at greatest, and frequently times the very same individual will select different categorizations for a given item at various times. The following is a easy approach to implement basic keyword search functionality utilizing SQL Server and absolutely nothing but. But - There is an alternative! SQL Search String and SQL Search Query - Envision you could quickly view your database entities, and drill down according to different criteria to get what you're looking for. Diana Lite helps you locate your way via all your database entities. Simply navigate through your tables, views, procedures and all over entities, across all your servers and databases. Discover specifically what you are looking for - then script it, view the data in it, do a search for a substring in an entity source, search through all tables to locate particular information in them, Browse through your code and swiftly answer questions like 'which procedures deletes from this table, or updates this table column' etc… (we are adding functions on a monthly basis) It Supports SQL Server (2005 - 2008R2) and MySQL. For now, its given completely free. Article Directory: http://www.articledashboard.com Daniel Z., Nobhill Software - Tools for Database People Check out our latest SQL Search tool |
|