create table T01 (a nvarchar(10), b nvarchar(10), c nvarchar(10), d nvarchar(10), e nvarchar(10), )create table T02 (c nvarchar(10), d nvarchar(10), e nvarchar(10), )insert into T01 values('a','b','c','d','e') insert into T02 values('c','d','e')declare @Code nvarchar(10) declare @Name nvarchar(10) set @code=a set @name=bINSERT INTO T01 SELECT @code,@name,* FROM T02select * from TO1drop table T0 drop table to1服务器: 消息 207,级别 16,状态 3,行 20 列名 'AA' 无效。 服务器: 消息 207,级别 16,状态 1,行 21 列名 'BB' 无效。
SORRY,惭愧,看错标题了。撤销2楼的回复。
AA BB哪来的? declare @Code nvarchar(10) declare @Name nvarchar(10) set @code='a' set @name='b'INSERT INTO T01 SELECT @code,@name,* FROM T02select * from TO1drop table T0 drop table to1
create table T0 (a nvarchar(10), b nvarchar(10), c nvarchar(10), d nvarchar(10), e nvarchar(10), )create table T01 (c nvarchar(10), d nvarchar(10), e nvarchar(10), )insert into T0 values('a','b','c','d','e') insert into T01 values('c','d','e')select * from T0 select * from T01declare @Code nvarchar(10) declare @Name nvarchar(10) set @code='a' set @name='b'INSERT INTO T0 SELECT @code,@name,* FROM T01select * from T0drop table T0 drop table T01
declare @Code nvarchar(10) declare @Name nvarchar(10) set @code='AA' set @name='BB'INSERT INTO T01 SELECT @code,@name,* FROM T02
declare @Name nvarchar(10) set @code=a
set @name=b
INSERT INTO T0
SELECT @code,@name,* FROM T01这个意思?
declare @Code nvarchar(10)
declare @Name nvarchar(10) select @Code = a from T0
select @Name = b from T0select @Code
select @Name
create table T01
(a nvarchar(10),
b nvarchar(10),
c nvarchar(10),
d nvarchar(10),
e nvarchar(10),
)create table T02
(c nvarchar(10),
d nvarchar(10),
e nvarchar(10), )insert into T01 values('a','b','c','d','e')
insert into T02 values('c','d','e')declare @Code nvarchar(10)
declare @Name nvarchar(10) set @code=a
set @name=bINSERT INTO T01
SELECT @code,@name,* FROM T02select * from TO1drop table T0
drop table to1服务器: 消息 207,级别 16,状态 3,行 20
列名 'AA' 无效。
服务器: 消息 207,级别 16,状态 1,行 21
列名 'BB' 无效。
declare @Code nvarchar(10)
declare @Name nvarchar(10) set @code='a'
set @name='b'INSERT INTO T01
SELECT @code,@name,* FROM T02select * from TO1drop table T0
drop table to1
(a nvarchar(10),
b nvarchar(10),
c nvarchar(10),
d nvarchar(10),
e nvarchar(10),
)create table T01
(c nvarchar(10),
d nvarchar(10),
e nvarchar(10), )insert into T0 values('a','b','c','d','e')
insert into T01 values('c','d','e')select * from T0
select * from T01declare @Code nvarchar(10)
declare @Name nvarchar(10) set @code='a'
set @name='b'INSERT INTO T0
SELECT @code,@name,* FROM T01select * from T0drop table T0
drop table T01
declare @Code nvarchar(10)
declare @Name nvarchar(10) set @code='AA'
set @name='BB'INSERT INTO T01
SELECT @code,@name,* FROM T02
set @name='b'这样也不行.