insert 不成功,不知为何?
表:
CREATE TABLE [dbo].[card] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[state] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[company] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[address] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[comp_class] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[vocation] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[products] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[grade] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[imageadd] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[newdate] [datetime] NULL ,
[modidate] [datetime] NULL
) ON [PRIMARY]
语句:
insert into card(state,name,company)
select 'READY',customername,companyname
from customer
where customername is not null;
错误:
Server: Msg 512, Level 16, State 1, Procedure t_insecordtr, Line 4
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.