alter table employee add semployeename nvarchar(20) not null default 第 1 行: 'default' 附近有语法错误。是怎么回事
-- ========================================= -- -----------t_mac 小编------------------- --------------------希望有天成为大虾---- -- =========================================IF OBJECT_ID('employee') IS NOT NULL DROP TABLE employee GO CREATE TABLE employee( a int ) go insert employee SELECT 1 alter table employee add semployeename varchar(20) not null default 'k'select * from employee go a semployeename ----------- -------------------- 1 k
alter table employee add semployeename varchar(20) not null default 'k'--这个semployeename字段添加默认值'k'
alter table employee add semployeename nvarchar(20) not null default ''
alter table employee add semployeename nvarchar(20) not null default ''
alter table employee add semployeename varchar(20) not null
然后使用alter table添加新字段时,并指定not null,就必须指定默认值
ALTER TABLE 只允许添加可包含空值或指定了 DEFAULT 定义的列。因为列 'semployeename' 不能包含空值且未指定 DEFAULT 定义,所以无法将该列添加到表 'products' 中。
第 1 行: 'default' 附近有语法错误。是怎么回事
-- -----------t_mac 小编-------------------
--------------------希望有天成为大虾----
-- =========================================IF OBJECT_ID('employee') IS NOT NULL
DROP TABLE employee
GO
CREATE TABLE employee( a int )
go
insert employee SELECT 1 alter table employee add semployeename varchar(20) not null default 'k'select * from employee
go
a semployeename
----------- --------------------
1 k