Sqlserver007

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 [...]

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 varchar(20) = ‘ [...]

Here is how you create a stored procedures with OutPut Parameter

The Execution is as follows

There are cases when SQL developers want to filter the results of Procedures Output. This requires inserting the results of the procedure in the table. Here is how it can be done
In the above example the temp table is created with the same columns as that of the procedure output, the Procedure is executed and [...]

Getting the list of tables and Columns that are embedded in a view ,function or a procedure is simple
sp_depends ‘viewName or ProcedureName‘
Documented in MSDN
http://msdn.microsoft.com/en-us/library/ms189487.aspx

Sql Server 2008’s new TOP statement could help update the Table in batches
Consider the following Example
The above code illustrates how the batchUpdate can be done using Top().
The top 100 records are updated depending on the criteria where fullname is null so that the same records dont get updated again