Sql 插入时候提示（当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式）

此情不渝 2017-06-17 03:55:51

SQL不是很熟悉，但是想在插入的时候搜索不同的情况，来获取插入的数据。

INSERT INTO T_TOOLPARA (DorA,IDENTIFY_NO,MATERIAL,OUTER_DIAMETRE,THICKNESS,HEAD_SHAPE,PUNCHCOUNT,PUNCH1,PUNCH1LIFE,PUNCH1CODE,PUNCH2,PUNCH2LIFE,PUNCH2CODE,PUNCH3,PUNCH3LIFE,PUNCH3CODE,MANDREL1,MANDREL1LIFE,MANDREL1CODE,MANDREL2,MANDREL2LIFE,MANDREL2CODE,MANDREL3,MANDREL3LIFE,MANDREL3CODE,CHUCK,CHUCKLIFE,CHUCKCODE) VALUES('A',(SELECT TOP 1 SUBSTRING(TOOL_SPECIFICATION,1,5)+'-9' FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9'),'SUS304',(SELECT TOP 1 SUBSTRING(TOOL_SPECIFICATION,3,1) FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9'),(SELECT TOP 1 SUBSTRING(TOOL_SPECIFICATION,13,3) FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9'),(SELECT TOP 1 SUBSTRING(TOOL_SPECIFICATION,1,5) FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9'),(SELECT COUNT(*) FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND SUBSTRING(TOOL_NAME,1,2)='头')

,(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='头1')

,(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='头2')

,(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='头3'),(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='棒1'),(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='棒2'),(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='棒3'),(SELECT TOOL_SPECIFICATION,THEORETICALLIFE,TOOL_CODE FROM T_TOOLSPECIFICATION WHERE GROUP_ID='9' AND TOOL_NAME='夹'))

...全文