Saturday, 14 July 2012

Using Primary Key with default.


Using Primary Key with default.........

create table demo
(EmpId int primary key,EmpSecondaryaddress varchar(200)
default 'not mention'
)

select *from demo

insert into demo (EmpId,EmpSecondaryaddress)
values (102,'noida')

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home