向表中填加数据的错误 你写成insert into table_test (fld1,fld2,fld3,....) select (......) from ...实验一下 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 肯定是字段数目不对,一个个往上加“insert into table_test(字段1,字段2,....) select f1,f2+3,.... from table_test” 把你的表结构贴出来试用insert into table_test (f1,f2....)select f1,f2+3,.... from table_test sql脚本如下if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[test]GOCREATE TABLE [dbo].[test] ( [BuyBillID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [PID] [int] NOT NULL , [Fixture] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL , [Place] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL , [Type] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL , [KindId] [bigint] NULL , [WarehouseNumber] [int] NULL , [BuyNumber] [int] NULL , [SpareNumber] [int] NULL , [Price] [money] NULL , [Total] AS ([Price] * [BuyNumber]) , [Memo] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [BuyProgress] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [PlanDatetime] [datetime] NULL , [LastDateTime] [datetime] NULL , [EnterOver] [bit] NULL , [EnterNumber] [int] NULL ) ON [PRIMARY]GO 我最不理解的是为什么用“insert into table_test select * from table_test”所出现的错误提示是“列名或所提供的值的数目和与表定义不匹配”;这样是不可能写少啊 sqlserver2005相对sqlserver2000有什么提升? 如何查询指定列相同的记录只显示一条 触发器问题?? 这个左外连接怎么做 我接手别人的程序,维护中遇到个问题,请大家指教,是插入纪录报错!~~~急!~~~ SQL关键字不高亮显示 如何创建一个同义词库 如何用SQL SERVER实现客户端与服务器的数据一致? 游标错误问题 能否将搜索结果替换原表格 请教一个sql语句! 定义游标时的问题?
“insert into table_test(字段1,字段2,....) select f1,f2+3,.... from table_test”
试用
insert into table_test (f1,f2....)
select f1,f2+3,.... from table_test
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[test]
GOCREATE TABLE [dbo].[test] (
[BuyBillID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PID] [int] NOT NULL ,
[Fixture] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
[Place] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
[Type] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
[KindId] [bigint] NULL ,
[WarehouseNumber] [int] NULL ,
[BuyNumber] [int] NULL ,
[SpareNumber] [int] NULL ,
[Price] [money] NULL ,
[Total] AS ([Price] * [BuyNumber]) ,
[Memo] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[BuyProgress] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[PlanDatetime] [datetime] NULL ,
[LastDateTime] [datetime] NULL ,
[EnterOver] [bit] NULL ,
[EnterNumber] [int] NULL
) ON [PRIMARY]
GO
所出现的错误提示是“列名或所提供的值的数目和与表定义不匹配”;
这样是不可能写少啊