SQL SERVER – Binary Sequence Generator – Truth Table Generator | Journey to SQL Authority with Pinal Dave

Run following script in query editor to generate truth table with its decimal value and binary sequence. The truth table is 512 rows long. This can be extended or reduced by adding or removing cross joins respectively. Script: USE AdventureWorks; DECLARE @Binary TABLE ( Digit bit) INSERT @Binary VALUES (0) INSERT @Binary VALUES (1) SELECT… Continue Reading...

Source: SQL SERVER – Binary Sequence Generator – Truth Table Generator | Journey to SQL Authority with Pinal Dave