急，这句应该怎么写？

[xyjnsdcn]

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type) values('b','连云港公司',select lsy from dt where AreaName='连云港公司','2003-3-27','30','31','1')

[xyjnsdcn]

我想把select lsy from dt where AreaName='连云港公司'取出的值放在表MESSAGE的DscCompany字段里

[Means_pan]

你可以分开导入,上面的语句语法就通不过

[syhxj]

select lsy from dt where AreaName='连云港公司'
这样查出来的会不会有重复值？

[xyjnsdcn]

没有重复值。

不能用组合语句直接写吗？

[huntsman]

试试这个：
select distinct lsy from dt where AreaName='连云港公司'

[ngqzmjmj]

是的select lsy from dt where areaname='连云港公司'
这样查出来的会不会有重复值。

[CrazyFor]

TRY:
exec('
insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type) values(''b'',''连云港公司'','''+(select lsy from dt where AreaName='连云港公司')+''',''2003-3-27'',''30'',''31'',''1'')
')

[yoki]

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type)
select 'b','连云港公司',top 1 lsy ,'2003-3-27','30','31','1'
from dt
where AreaName='连云港公司

[yoki]

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type)
select 'b','连云港公司',lsy ,'2003-3-27','30','31','1'
from dt
where AreaName='连云港公司

[zjcxc]

你可以这样子写嘛:

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type) select 'b' as SrcUser,'连云港公司' as SrcCompany,lsy as DscCompany,'2003-3-27' as SrcDate,'30' as Vday,'31' as Object,'1' as type from dt where AreaName='连云港公司'

当然,如果你想保证只插入一个值的话,加上 top 1,像下面

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type) select top 1 'b' as SrcUser,'连云港公司' as SrcCompany,lsy as DscCompany,'2003-3-27' as SrcDate,'30' as Vday,'31' as Object,'1' as type from dt where AreaName='连云港公司'

[CrazyFor]

OR:

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type)
select 'b','连云港公司',lsy ,'2003-3-27','30','31','1' from dt where AreaName='连云港公司'

[xyjnsdcn]

不好意思，还没揭贴。

也就是说不能把SELECT出的值直接作为要INSERT的值

[xyjnsdcn]

是吗？

[triout]

insert into Message (SrcUser,SrcCompany,DscCompany,SrcDate,Vday,Object,type)
select 'b','连云港公司',top 1 lsy ,'2003-3-27','30','31','1'
from dt
where AreaName='连云港公司

[xyjnsdcn]

哦，我明白了。不好意思。

[egg629]

我就不用写了，帮忙顶了。
UP：）