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 –…

Delimited String Split – XML Parsing Method

I’d blogged previously on a string splitting function which splits up CSV onto individual valueshttp://visakhm.blogspot.in/2010/02/parsing-delimited-string.htmlThe same scenario can be handled by means of XML functions too. This blog provides a method of splitting up of delimited string into its component…