.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

CHECKSUM_AGG( BINARY_CHECKSUM( ID ) ) as a bigint

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
 
I'm doing Select CHECKSUM_AGG(BINARY_CHECKSUM( OP.ID ) FROM objPlat OP WHERE OP.oID = O.oID table OP has 10244 rows table O has 2425 rows My number being returned ends up being negative, so I'm guessing that means it's hitting the int limit.  Is there any way to use this as a bigint or is there another way to do it? Thanks in advance


View Complete Post


More Related Resource Links

checksum_agg overflow

  
if i use checksum_agg(checksum(*)) from table A i had noticed that sometimes checksum_agg overflows - eg gives the same results for different sets of data   is there  a way to get better checksum - eg average?    

Please anyone can explain CHECKSUM_AGG

  

Hi,

Please anyone can explain CHECKSUM_AGG. I want to know what it is doing exactly.

Use below queries to explain it.

 

SELECT

 

CHECKSUM_AGG(TBL.Number) AS CHECK_SUM_AGG

How to conver Binary data into bigint

  

I have table it is having data like thius

0x0000436692870000

 

I want to conver it into bigint


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend