I have 20 Databases in my production Server and the tables in some database are used by the Views , functions and procedures of some Other Databases. Now I want to find out the Dependencies of the Tables and their Database Location. I can use the following Dynamic SQL to get the SQL statements and [...]
Apr
27
2009
27
2009
Apr
27
2009
27
2009
Splitting Website URL in TSQL
Recently I was involved in a task of splitting the URL’s and generating some reference based on them. I started looking around on google and found this function Split from http://www.otecode.com. This Table Valued function returns a list of substring based on the literal you specify as parameter create function [fn_Split] ( @text varchar(8000) ,@Delimiter [...]
