Chris Hanna Showcase

Very Basic SQL Statements

Update Row If It Exists Else Update:

IF EXISTS 
    (SELECT * FROM Table1 WHERE Column1='SomeValue')
    UPDATE Table1 SET (...) 
    WHERE Column1='SomeValue'
ELSE
    INSERT INTO Table1 VALUES (...)

Find Procs That Depend On Column:

 SELECT obj.Name SPName, sc.TEXT SPText
    FROM sys.syscomments sc
    INNER JOIN sys.objects obj 
        ON sc.Id = obj.OBJECT_ID
    WHERE sc.TEXT LIKE 
    '%' + 'Name Your Column Here' + '%' 
    AND TYPE = 'P'

*Please, excuse SQL formating.