1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SELECT TOP 5 ID,ROW_NUMBER() OVER ( ORDER BY ID ) 'RowNum' ,(SELECT hashbytes('md5', ( SELECT [YFP_DATA] FOR XML RAW,BINARY BASE64 ))) 'HashCkSum'
FROM [YFILEPARTS];
SELECT TOP 50 ID,ROW_NUMBER() OVER ( ORDER BY ID ) 'RowNum' ,
Convert(NVARCHAR(MAX),
(SELECT hashbytes('md2', ( SELECT [YFP_DATA] FOR XML RAW,BINARY BASE64 ))),
1) 'HashCkSum'
FROM [YFILEPARTS] ;
SELECT TOP 100 ID,ROW_NUMBER() OVER ( ORDER BY ID ) 'RowNum' ,
( SELECT [YFP_DATA] FOR XML RAW,BINARY BASE64 ) 'HashCkSum'
FROM [YFILEPARTS] ;
SELECT TOP 100 ID,hashbytes('SHA1',[YFP_DATA])
FROM [YFILEPARTS] ;
Select Checksum(*) as H, * From [YFILEPARTS]; |
Partager