Default int type value and default char type value : Default « Constraints « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Constraints
3. Default

2> CREATE TABLE xyz
3> (
4> col1    int            PRIMARY KEY IDENTITY(1, 1) NOT NULL,
5> col2    int            NOT NULL DEFAULT 999,
6> col3    char(10)       NOT NULL DEFAULT 'ABCEFGHIJK'
7> )
8> GO
1>
2> SET NOCOUNT ON
3> DECLARE @counter int
4> SET @counter=1
5> WHILE (@counter <= 1000)
6>     BEGIN
7>     INSERT xyz DEFAULT VALUES
8>     SET @counter=@counter+1
9>     END
10> GO
1>
2>
3> drop table xyz;
4> GO