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





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










7.6.Default
7.6.1.The syntax for defining a default
7.6.2.DEFAULT Constraints
7.6.3.Default int type value and default char type value
7.6.4.Using the system date as a default parameter.
7.6.5.Column with default random value
7.6.6.Insert to a table with default value
7.6.7.Designating Default Column Values: Assign Zeroes Instead of Null Values
7.6.8.Dropping Defaults