RIM Singh

RIM Singh

  • 1.8k
  • 47
  • 16.7k

sql query

Jun 19 2013 8:58 AM
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?

Answers (2)