一简单SQL请加大帮忙改改！在insert语句中使用select，而select中要组合字符串
在insert语句中使用select不？我想把ProductID,ProductName 组合在一个查询中作
insert into T_LeaguerOrderDetail(SerialNumber,OrderID,ProductID,ProductName,
ProductPrice,ProductNumber,OperatingPersonnel)
values
( 'wang520d ', '123 ', '2562 ',
select Convert(varchar,productName) + ', ' + Convert(varchar,actressprice) from T_Product_List where Listid =2562
,
123, 'wang520d ')
[解决办法]
insert into T_LeaguerOrderDetail(SerialNumber,OrderID,ProductID,ProductName,ProductPrice,ProductNumber,OperatingPersonnel)
select 'wang520d ', '123 ', '2562 ',Convert(varchar,productName) + ', ' + Convert(varchar,actressprice),123, 'wang520d ' from T_Product_List where Listid =2562
[解决办法]
insert into T_LeaguerOrderDetail
(SerialNumber,OrderID,ProductID,ProductName,ProductPrice,ProductNumber,OperatingPersonnel)
select 'wang520d ', '123 ', '2562 ',cast(productName as varchar) + ', ' + cast(actressprice as varchar),123, 'wang520d ' from T_Product_List where Listid = 2562
[解决办法]
你想实现什么啊?
declare @ProName varchar 50;
declare @ProPri varchar 50;
select @PruName=Convert(varchar,productName) ,@ProPri=
Convert(varchar,actressprice) from T_Product_List where Listid =2562;
insert into T_LeaguerOrderDetail(SerialNumber,OrderID,ProductID,ProductName,
ProductPrice,ProductNumber,OperatingPersonnel)
values
( 'wang520d ', '123 ', '2562 ',@PruName,@ProPri,123, 'wang520d ')
[解决办法]
insert into T_LeaguerOrderDetail
(SerialNumber,OrderID,ProductID,ProductName,ProductPrice,ProductNumber,OperatingPersonnel)
select 'wang520d ', '123 ', '2562 ',cast(productName as varchar) , cast(actressprice as varchar),123, 'wang520d ' from T_Product_List where Listid = 2562
