declare @tb table (a varchar(10))
insert into @tb select 1 abc
select * from @tb declare @tb table (a varchar(10))
insert into @tb select 1 as abc
select * from @tb
insert into @tb select 1 abc
select * from @tb declare @tb table (a varchar(10))
insert into @tb select 1 as abc
select * from @tb
abc
-----------
1(1 row(s) affected)
可为什么把abc当成了别名呢?而不是把bc或c当作别名呢?
declare @tb table (a varchar(10))
insert into @tb select 1bc
select * from @tb
=========
declare @tb table (a varchar(10))
insert into @tb select 1 bc
select * from @tb
=========
declare @tb table (a varchar(10))
insert into @tb select 1 as bc
select * from @tb
=========
declare @tb table (a varchar(10))
insert into @tb select cast(1 as varchar(10)) as bc
select * from @tb
select abcd
就会抱错
只有前面是数字
select 123sab
sab
123
多谢