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

Content with tag hash Rss

   Items 1 to 3 of 3   

Using hash values in SSIS to determine when to insert or update rows

A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.  Read more...
By Additional Articles 2014/02/25 | Source: | Category: hash
Rating: (not yet rated)  Rate this |   Briefcase | 2,847 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...
By Bret Lowery 2012/02/20 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,288 reads

Comparing a hash

By alastors 2010/02/01 | Category: comparing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,392 reads
   Items 1 to 3 of 3   
c# (1)    
comparing (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
function (1)    
functions (1)    
hashing (1)    
integration services (ssis) (1)    
replicate (1)    
sqlclr (1)    
t-sql (1)