653      阿裏雲  技術社區[雲棲]

Subqueries are not allowed in this context. Only scalar expressions are allowed.

我想獲取表中某一列的最大值，然後插入到另外一個表中，報錯的Sql如下：

insert into AA(AA_ID,AA_YWFSRQ) 
values
(NewID(),(  SELECT   CONVERT(varchar, DATEADD(day,- 1, CAST(SUBSTRING(MAX(YEB_RQ), 1, 4) 
                                    + SUBSTRING(MAX(YEB_RQ), 5, 2) + SUBSTRING(MAX(YEB_RQ), 7, 2) 
                                     AS datetime)), 112) FROM      YEB ));

insert into AA(AA_ID,AA_YWFSRQ) 
select
NewID(),(  SELECT   CONVERT(varchar, DATEADD(day,- 1, CAST(SUBSTRING(MAX(YEB_RQ), 1, 4) 
                                    + SUBSTRING(MAX(YEB_RQ), 5, 2) + SUBSTRING(MAX(YEB_RQ), 7, 2) 
                                     AS datetime)), 112) FROM      YEB )

==》在此上下文中不允許使用子查詢。隻允許使用標量表達式。

最後更新：2017-04-03 20:19:25

  上一篇： Sql_Server中如何判斷表中某列是否存在

  下一篇： C# WinForm多線程開發（二） ThreadPool 與 Timer