Monday, 14 November 2016

SQL SERVER GET CHECK SUM GETCHECKSUM FORMULA

SQL SERVER GET CHECK SUM GETCHECKSUM FORMULA

-- THEORY

-- SELECT Column1, GETCHECKSUM(Column1) AS [Alias_Name]
-- FROM AdventureWorksDW2012.DBO.DimAccount AS ACC;

-- EXAMPLE

SELECT ACC.AccountKey, GETCHECKSUM(ACC.AccountKey) AS [GETCHECKSUM]
FROM AdventureWorksDW2012.DBO.DimAccount AS ACC;

No comments:

Post a Comment