i have created a table.
CREATE TABLE [dbo].[tbl_Employee](
[empid] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](100) NULL,
[salary] [int] NULL
)
its workin fine, now i want that if i do not insert salary column then it does not enter null, it add any value like 1000
how can i do it?