SELECT
CAST(DATEPART(YEAR, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(month, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(day, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) AS Riqi, COUNT(1) AS ComNumFROM dbo.account INNER JOIN
dbo.company ON dbo.account.AccountId = dbo.company.AccountId LEFT OUTER JOIN
dbo.PwdCMD ON dbo.company.AccountId = dbo.PwdCMD.AccountId
GROUP BY Riqi在视图中报错“列名Riqi 无效”
CAST(DATEPART(YEAR, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(month, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(day, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) AS Riqi, COUNT(1) AS ComNumFROM dbo.account INNER JOIN
dbo.company ON dbo.account.AccountId = dbo.company.AccountId LEFT OUTER JOIN
dbo.PwdCMD ON dbo.company.AccountId = dbo.PwdCMD.AccountId
GROUP BY Riqi在视图中报错“列名Riqi 无效”
解决方案 »
- 如何在已存在的一张表中创建新列
- 怎么样在sqlserver2000 建链接服务器到 sqlserver2005 ?
- SQL Server 2005 为什么不能导入 Access
- 删除本数据库所有作业(jobs)的T-SQL语句(求更好的办法)
- 如何用SQL计算两个日期差
- xp 32 系统装不了 2005
- /3g /pae awe 我这样理解对不对???
- 如何禁止sa访问私人数据?
- 无法安装SQL Server 2000
- :)读取*.sql文件生成 sql server 7 的数据库的方法! 作者:panjiaohong-----转载
- 如何将列值转成行显示,并且可以设置不同的背景色?
- 存储过程判断路径有问题 请高手指点 在线等
CAST(DATEPART(YEAR, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(month, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(day, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) AS Riqi, COUNT(1) AS ComNumFROM dbo.account INNER JOIN
dbo.company ON dbo.account.AccountId = dbo.company.AccountId LEFT OUTER JOIN
dbo.PwdCMD ON dbo.company.AccountId = dbo.PwdCMD.AccountId
GROUP BY CAST(DATEPART(YEAR, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(month, dbo.PwdCMD.Pwd_SendDate) AS varchar(255)) + '-' + CAST(DATEPART(day, dbo.PwdCMD.Pwd_SendDate) AS varchar(255))
SELECT
convert(varchar(10),dbo.PwdCMD.Pwd_SendDate,120) AS Riqi, COUNT(1) AS ComNumFROM dbo.account INNER JOIN
dbo.company ON dbo.account.AccountId = dbo.company.AccountId LEFT OUTER JOIN
dbo.PwdCMD ON dbo.company.AccountId = dbo.PwdCMD.AccountId
GROUP BY convert(varchar(10),dbo.PwdCMD.Pwd_SendDate,120)