求助:SQL问题
我知道公摄有一批包括老柞在内的优秀IT青年。今天遇到这个问题,怎么也闯不过去,请帮忙分析一下,这句错在哪里:$query = "SELECT * , 'DrawingNo' = CASE WHEN len()=9 THEN 'A' ELSE 'B' ENDFROM dbo.Drawings where left(,5)='$dwgGroup' and Obsolete='false' and Existance='true' and Appd<>'null' and Sleep='False'";
PHP 连接到 MSSQL
其中“A" 和 ”B"是一段表达式的简化,便于阅读。 行了:
$query = "SELECT * , (CASE when len()=9 then ‘A' else 'B' end) as DrawingNoFROM dbo.Drawings where left(,5)='$dwgGroup' and Obsolete='false' and Existance='true' and Appd<>'null' and Sleep='False'";
以前用PHP都是用Mysql,MSSQL还是第一次。
最后使用的句子:
$query = "SELECT * , (CASE when len()=9 then left(,6) + '0' + right(,3) else end) as DrawingNoFROM dbo.Drawings where left(,5)='$dwgGroup' and Obsolete='false' and Existance='true' and Appd<>'null' and Sleep='False' ORDER BY DrawingNo ASC";
页:
[1]