CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40)) GO INSERT INTO products (product) VALUES ('screwdriver') INSERT INTO products (product) VALUES ('hammer') INSERT INTO products (product) VALUES ('saw') INSERT INTO products (product) VALUES ('shovel') GO DELETE products WHERE product = 'saw' GO SELECT * FROM products GO SET IDENTITY_INSERT products ON GO INSERT INTO products (id, product) VALUES(3, 'garden shovel') GO SELECT * FROM products GO DROP TABLE products GO
我想你有点不了解吧.. 联机丛书是为了说明SET IDENTITY_INSERT的作用才故意产生错误的.如果我不想错误.那这样就好了.CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40)) GO -- Inserting values into products table. INSERT INTO products (product) VALUES ('screwdriver') INSERT INTO products (product) VALUES ('hammer') INSERT INTO products (product) VALUES ('saw') INSERT INTO products (product) VALUES ('shovel') GO -- Create a gap in the identity values. DELETE products WHERE product = 'saw' GO SELECT * FROM products GO -- Attempt to insert an explicit ID value of 3; -- should return a warning. --在这里加 SET IDENTITY_INSERT products ON SET IDENTITY_INSERT products ON INSERT INTO products (id, product) VALUES(3, 'garden shovel') GO -- SET IDENTITY_INSERT to ON. GO SELECT * FROM products GO -- Drop products table. DROP TABLE products GO
那这样的语句如何调才能解决问题呢SET IDENTITY_INSERT AwordTab on insert into AwordTab select AwordID,bookName,AwordName,AwordUnit,AwordDate from OpenDataSource( 'SQLOLEDB', 'Data Source=web;User ID=sa;Password=').lin.dbo.AwordTab
GO
INSERT INTO products (product) VALUES ('screwdriver')
INSERT INTO products (product) VALUES ('hammer')
INSERT INTO products (product) VALUES ('saw')
INSERT INTO products (product) VALUES ('shovel')
GO DELETE products
WHERE product = 'saw'
GO SELECT *
FROM products
GO
SET IDENTITY_INSERT products ON
GO INSERT INTO products (id, product) VALUES(3, 'garden shovel')
GO SELECT *
FROM products
GO DROP TABLE products
GO
联机丛书是为了说明SET IDENTITY_INSERT的作用才故意产生错误的.如果我不想错误.那这样就好了.CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40))
GO
-- Inserting values into products table.
INSERT INTO products (product) VALUES ('screwdriver')
INSERT INTO products (product) VALUES ('hammer')
INSERT INTO products (product) VALUES ('saw')
INSERT INTO products (product) VALUES ('shovel')
GO -- Create a gap in the identity values.
DELETE products
WHERE product = 'saw'
GO SELECT *
FROM products
GO -- Attempt to insert an explicit ID value of 3;
-- should return a warning. --在这里加 SET IDENTITY_INSERT products ON
SET IDENTITY_INSERT products ON INSERT INTO products (id, product) VALUES(3, 'garden shovel')
GO
-- SET IDENTITY_INSERT to ON. GO
SELECT *
FROM products
GO
-- Drop products table.
DROP TABLE products
GO
select AwordID,bookName,AwordName,AwordUnit,AwordDate from OpenDataSource( 'SQLOLEDB', 'Data Source=web;User ID=sa;Password=').lin.dbo.AwordTab
[AwordID] [int] IDENTITY (1, 1) NOT NULL ,
[bookName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[AwordName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[AwordUnit] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[AwordDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]当然有了
select AwordID,bookName,AwordName,AwordUnit,AwordDate from OpenDataSource( 'SQLOLEDB', 'Data Source=web;User ID=sa;Password=').lin.dbo.AwordTab
原来这样就行,。
insert into AwordTab ( AwordID,bookName,AwordName,AwordUnit,AwordDate )
select AwordID,bookName,AwordName,AwordUnit,AwordDate from OpenDataSource( 'SQLOLEDB', 'Data Source=web;User ID=sa;Password=').lin.dbo.AwordTab
不是SET IDENTITY_INSERT AwordTab on 的错,,,,杀错人了