设置默认值



CREATE TABLE 人员
（
P_Id int NOT NULL ，
LastName varchar （ 255 ） NOT NULL ，
FirstName varchar （ 255 ），
地址 varchar （ 255 ），
City varchar （ 255 ） DEFAULT ' Sandnes'
）

参考

http：/ /www.w3schools.com/sql/sql_default.asp [ ^ ]

Dear Friends,

How to set/inset default value like Email is not available for Email column (if column value is null/empty) in Student table.

Note: I don't want to use select query.


Ex:

Student

SId SName Email Address
1 Raju raju@gmail.com bangalore
2 Reddy bangalore
3 Sita bangalore
4 Ravi ravi@gmail.com bangalore
5 Ramu bangalore

Expected Output

SId SName Email Address
1 Raju raju@gmail.com bangalore
2 Reddy Email NA bangalore
3 Sita Email NA bangalore
4 Ravi ravi@gmail.com bangalore
5 Ramu Email NA bangalore

Thanks in advance.

Set default values

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255) DEFAULT 'Sandnes'
)

Refer
http://www.w3schools.com/sql/sql_default.asp[^]