sql语句在查询分析器里面正确，代码执行报错。
sql语句如下：
select CONVERT(varchar(10),uc.pay_time,3) pay_time
,COUNT(*) xiaofeishuliang
,SUM(CONVERT(decimal(18,2),uc.amount)) xiaofeizongji
,SUM(CONVERT(decimal(18,2),uc.amount)) shijizongji
,SUM(CONVERT(decimal(18,2),uc.amount))/COUNT(*) renjun
from ucpayorder as uc
where uc.gameId=504002
group by uc.pay_time
CREATE TABLE #TESTT(gameId INT IDENTITY(1,1) PRIMARY KEY,pay_time DATETIME,amount INT)
SELECT * FROM #TESTT
INSERT INTO #TESTT VALUES (GETDATE(),100)
SELECT CONVERT(VARCHAR(10),t.pay_time,3) AS 'pay_time',
COUNT(1) AS 'xiaofeishuliang' ,
SUM(CONVERT(DECIMAL(18,2),T.amount))AS 'xiaofeizongji',
SUM(CONVERT(DECIMAL(18,2),T.amount))AS 'shijizongji',
avg(CONVERT(DECIMAL(18,2),T.amount))AS 'renjun'
FROM #TESTT t
GROUP BY t.pay_time
GO
/*
* Result:
*
pay_time xiaofeishuliang xiaofeizongji shijizongji renjun
---------- --------------- ---------------- ----------------- ---------------
24/07/13 1 100.00 100.00 100.000000
(1 row(s) affected)
*/
/*
* -------------------------------------
* 楼主的：
* -------------------------------------
*/
select?CONVERT(varchar(10),uc.pay_time,3) AS?'pay_time'
????????,COUNT(1) AS?'xiaofeishuliang'?
????????,SUM(CONVERT(decimal(18,2),uc.amount)) AS?'xiaofeizongji'?
????????,SUM(CONVERT(decimal(18,2),uc.amount)) AS?'shijizongji'?
????????,AVG(CONVERT(decimal(18,2),uc.amount)) AS?'renjun'
from?#TESTT AS?uc
where?uc.gameId=504002??
group?by?uc.pay_time?
/*
Msg 102, Level 15, State 1, Line 1
'?' 附近有语法错误。
找了半天反正没找到
*/
