Binary Math windows server 2008 sql server 2008 r2

5 pts.
Tags:
SQL Server 2008 R2
User Permissions
Windows Server 2008
Operating System: Windows 2008 2 Database: SQL Server 2008 Enterprise R2 issue: I am trying to creat a binary matrix that manages user permissions. My largest number at present is 135069719 the binary representation is : 101001001110000101001 The largest number I eventually have to handle is a 20 digit decimal number Is this possible?

Answer Wiki

Thanks. We'll let you know when a new response is added.

So you are using a bitwise operator to figure out what permissions a user has? What data type are you using? BIGINT supports a value up to 9,223,372,036,854,775,807. You might want to find a better way to store permissions.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    "Is this possible?": What exactly is "this" ? Is it creating the matrix, or storing the numbers, or what ? We would need to know how you are creating that matrix, and where and how you are storing the numbers.
    69,510 pointsBadges:
    report
  • m76853
    [...] Binary Math Windows Server 2008 SQL Server 2008 R2, asked by M76853 and discussed by mrdenny and carlosdl. Head over and shed your light on [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following