Loading

sql query

RIM Singh

13y1.6k

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
Accepted answer
use this..

CREATE TABLE [dbo].[tbl_Employee](
    [empid] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](100) NULL,
    [salary] [int] default 1000
)

you can put any value on place of 1000

mark as answered if helpfull.
RIM Singh13y ago
thanks
it works