当前位置: 代码迷 >> Sql Server >> 即急求教一个sql语句,该怎么解决
  详细解决方案

即急求教一个sql语句,该怎么解决

热度:73   发布时间:2016-04-27 13:51:00.0
即急!求教一个sql语句
insert into dbo.T_Money values((select ti.ID from dbo.T_Item as ti where [email protected]),@moneyp,@datetimep,@username,@remarkp)


这个sql语句执行起来总是说。子查询错误。。。求应该怎么改。。。

------解决方案--------------------
SQL code
insert into dbo.T_Money values((select TOP 1 ti.ID from dbo.T_Item as ti where [email protected]),@moneyp,@datetimep,@username,@remarkp)
------解决方案--------------------
SQL code
INSERT  INTO dbo.T_Money        SELECT  ( SELECT    ti.ID                  FROM      dbo.T_Item AS ti                  WHERE     ti.item = @itemp                ) ,                @moneyp ,                @datetimep ,                @username ,                @remarkp
------解决方案--------------------
insert into dbo.T_Money 
select ti.ID ,@moneyp,@datetimep,@username,@remarkp
from dbo.T_Item as ti where [email protected]
------解决方案--------------------
SQL code
insert into dbo.T_Money select ti.ID ,@moneyp,@datetimep,@username,@remarkpfrom dob.T_Item as ti where ti.item = @itemp
------解决方案--------------------
insert into dbo.T_Money 
select (select ti.ID from dbo.T_Item as ti where [email protected]),@moneyp,@datetimep,@username,@remarkp
弄错了

------解决方案--------------------
SQL code
INSERT  INTO dbo.T_Money        SELECT  ti.ID, @moneyp, @datetimep, @username, @remarkp        FROM    dbo.T_Item AS ti        WHERE   ti.item = @itemp
------解决方案--------------------
SQL code
insert into dbo.T_Money values((select top 1 ti.ID from dbo.T_Item as ti where [email protected]),@moneyp,@datetimep,@username,@remarkp)
  相关解决方案