Count int1 values (implicitly non-null) : integer « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. integer

4> CREATE TABLE T (
5>     int1 int,
6>     bit1 bit,
7>     varchar1 varchar(3),
8>     dec1 dec(5,2),
9>     cmp1 AS (int1 + bit1)
10> )
11> GO
1>
2> INSERT T (int1, bit1) VALUES (1, 0)
3> INSERT T (int1, varchar1) VALUES (2, 'abc')
4> INSERT T (int1, dec1) VALUES (3, 5.25)
5> INSERT T (bit1, dec1) VALUES (1, 9.75)
6> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1> SELECT COUNT(int1) 'int1 values in T'
2> FROM T
3> GO
int1 values in T
----------------
               3
Warning: Null value is eliminated by an aggregate or other SET operation.
1> drop table t;
2> GO
1>
2>
3>