Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts by Larry Schmidt profile

   Items 1 to 2 of 2   

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.  Read more...
By Larry Schmidt 2014/11/17 | Source: | Category: date
Rating: |  Discuss |   Briefcase | 1,291 reads

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.  Read more...
By Larry Schmidt 2012/12/17 | Source: | Category: trigger
Rating: |  Discuss |   Briefcase | 1,016 reads
   Items 1 to 2 of 2