当前位置: 代码迷 >> Sql Server >> 大家帮忙看一下这条语句的有关问题
  详细解决方案

大家帮忙看一下这条语句的有关问题

热度:79   发布时间:2016-04-27 20:49:57.0
大家帮忙看一下这条语句的问题
INSERT   INTO   ExpertWord
            (SoundPath,   SendTel,   ExpertName,   ExpertType,   RecvTel,   LeftTime,   bPublic)
VALUES   (SELECT   SoundPath,   SendTel,   ExpertName,   ExpertType,   ' '   AS   RecvTel,   LeftTime,  
                                1   AS   bPublic
                    FROM   ExpertPublicWord
                    WHERE   (ID   IN
                                        (SELECT   MIN(ID)
                                      FROM   ExpertPublicWord))   AND   (bAct   =   0))

报select附近有语发错误
但单独执行
SELECT   SoundPath,   SendTel,   ExpertName,   ExpertType,   ' '   AS   RecvTel,   LeftTime,  
                                1   AS   bPublic
                    FROM   ExpertPublicWord
                    WHERE   (ID   IN
                                        (SELECT   MIN(ID)
                                      FROM   ExpertPublicWord))   AND   (bAct   =   0)是对的


------解决方案--------------------
去掉values和括号
------解决方案--------------------
INSERT INTO ExpertWord
(SoundPath, SendTel, ExpertName, ExpertType, RecvTel, LeftTime, bPublic)
--VALUES (
SELECT SoundPath, SendTel, ExpertName, ExpertType, ' ' AS RecvTel, LeftTime,
1 AS bPublic
FROM ExpertPublicWord
WHERE (ID IN
(SELECT MIN(ID)
FROM ExpertPublicWord)) AND (bAct = 0)
--)
  相关解决方案