Labels

admin (1) aix (1) alert (1) always-on (2) Architecture (1) aws (3) Azure (1) backup (3) BI-DWH (10) Binary (3) Boolean (1) C# (1) cache (1) casting (3) cdc (1) certificate (1) checks (1) cloud (3) cluster (1) cmd (7) collation (1) columns (1) compilation (1) configurations (7) Connection-String (2) connections (6) constraint (6) copypaste (2) cpu (2) csv (3) CTE (1) data-types (1) datetime (23) db (547) DB2 (1) deadlock (2) Denali (7) device (6) dotNet (5) dynamicSQL (11) email (5) encoding (1) encryption (4) errors (124) excel (1) ExecutionPlan (10) extended events (1) files (7) FIPS (1) foreign key (1) fragmentation (1) functions (1) GCP (2) gMSA (2) google (2) HADR (1) hashing (3) in-memory (1) index (3) indexedViews (2) insert (3) install (10) IO (1) isql (6) javascript (1) jobs (11) join (2) LDAP (2) LinkedServers (8) Linux (15) log (6) login (1) maintenance (3) mariadb (1) memory (4) merge (3) monitoring (4) MSA (2) mssql (444) mssql2005 (5) mssql2008R2 (20) mssql2012 (2) mysql (36) MySQL Shell (5) network (1) NoSQL (1) null (2) numeric (9) object-oriented (1) offline (1) openssl (1) Operating System (4) oracle (7) ORDBMS (1) ordering (2) Outer Apply (1) Outlook (1) page (1) parameters (2) partition (1) password (1) Performance (103) permissions (10) pivot (3) PLE (1) port (4) PostgreSQL (14) profiler (1) RDS (3) read (1) Replication (12) restore (4) root (1) RPO (1) RTO (1) SAP ASE (48) SAP RS (20) SCC (4) scema (1) script (8) security (10) segment (1) server (1) service broker (2) services (4) settings (75) SQL (74) SSAS (1) SSIS (19) SSL (8) SSMS (4) SSRS (6) storage (1) String (35) sybase (57) telnet (2) tempdb (1) Theory (2) tips (120) tools (3) training (1) transaction (6) trigger (2) Tuple (2) TVP (1) unix (8) users (3) vb.net (4) versioning (1) windows (14) xml (10) XSD (1) zip (1)
Showing posts with label Binary. Show all posts
Showing posts with label Binary. Show all posts

Convert From Binary to Decimal

1. Get the last digit of the hex number, call this digit the currentDigit.  
2. Make a variable, let's call it power.  Set the value to 0.
3. Multiply the current digit with (2^power), store the result.
4. Increment power by 1.
5. Set the the currentDigit to the previous digit of the hex number.
6. Repeat step 3 until all digits have been multiplied.
7. Sum the result of step 3 to get the answer number.

1010001 = 81
(1*1) + (0*2) + (0*4) + (0*8) + (1*16) + (0*32) + (1*64) =
  1   +   0   +   0   +   0   +   16   +   0    +   64   = 81


Binary / Decimal Converter Calculator:

"There are 10 types of people in this world. Those who do understand binary and those who don't." :-)

Convert From Decimal to Binary

1. Determine if your decimal number is 0 or 1. If it is either of these numbers, the binary number is the same as the decimal number. If it is not either of these numbers, move on to Step 2.
2. Find the largest possible power of 2 that can be subtracted from the decimal number without making it negative. Then, subtract it.
3. Write a "1" as the first digit of your binary number.
4. Decide whether you can subtract the next smallest power of 2 from what is left of the decimal number without making it negative.
5. Deduct this power of 2 from the decimal number and write "1" as the next digit of your binary number if your results were positive for Step 5. If they were negative, write "0" as the next digit of your binary number.
6. Repeat Step 5 and 6 until you reach the number 0. The numbers you write down during this process are the binary number.

Binary / Decimal Converter Calculator:

"There are 10 types of people in this world. Those who do understand binary and those who don't." :-)

Mathematical & Binary Operators & Functions

Operators
+ addition

- subtraction
* multiplication
/ division
% modulo (remainder) 5 % 4 1
^ exponentiation
|/ square root
||/ cube root
! factorial 5 !=120
!! factorial (prefix operator) !!5=120
@ absolute value
& binary AND
| binary OR
# binary XOR
~ binary NOT
<< binary shift left
>> binary shift right


Bit String Binary Operators
B'10001' & B'01101' = 00001
B'10001' | B'01101' = 11101
B'10001' # B'01101' = 11110
~ B'10001' = 01110
B'10001' << 3 = 01000
B'10001' >> 2 = 00100


Functions
abs(x) - absolute value
cbrt(dp) - cube root
ceil(dp or numeric) - smallest integer not less than argument
degrees(dp) - radians to degrees
exp(dp or numeric) - exponential
floor(dp or numeric) - largest integer not greater than argument
ln(dp or numeric) - natural logarithm
log(dp or numeric) - base 10 logarithm
log(b numeric, x numeric) - logarithm to base b
mod(y, x) - remainder of y/x
pi() - "Pi" constant
pow(x dp, e dp) - raise a number to exponent e
pow(x numeric, e numeric) - raise a number to exponent e
radians(dp) - degrees to radians
random() - random value between 0.0 and 1.0
round(dp or numeric) - round to nearest integer
round(v numeric, s integer) - round to s decimal places
sign(dp or numeric) - sign of the argument (-1, 0, +1)
sqrt(dp or numeric) - square root
trunc(dp or numeric) - truncate toward zero
trunc(v numeric, s integer) - truncate to s decimal places