Wildcard based character search using PATINDEX

This is a follow up of the below blog on wildcard character based searchhttp://visakhm.blogspot.in/2013/01/wildcard-character-based-pattern-search.html Extending this further, I did some experiments on how various wildcard characters will work inside pattern in t-sql .Lets see how we can apply similar logic…

system_sql_modules and all_sql modules views

Previously I’d blogged on the advantages of using sys.sql_modules view here http://visakhm.blogspot.in/2012/03/advantages-of-using-syssqlmodules-view.html There are two more related views available from SQL 2005 onwards. They’re sys.system_sql_modules and sys.all_sql_modules. So how are they different from sys.sql_modules? The difference is as followssys.sql_modules –…