Select Count(1) dealQty, F_Name, F_Key,0 as edrPOSQty
into test3 From test Where F_DealDate is not null
group by F_Name, F_Key
edrPOSQty 是新增字段, 需要设置为DECIMAL
怎么做,谢谢
into test3 From test Where F_DealDate is not null
group by F_Name, F_Key
edrPOSQty 是新增字段, 需要设置为DECIMAL
怎么做,谢谢
解决方案 »
- sql server2000中对一个表建日志系统
- 2000升级到2005变慢
- 临时表建立索引问题
- 关于jdbc连接sqlserver存储过程内部的变量问题,请高手们帮忙!!!!
- 混合模式下连接SQL Server是否需要先用Windows帐号登录服务器?
- 我要被害死了!为什么我昨天刚刚备份的数据库,在今天恢复,但是恢复后的数据却是好多天以前的了!而不是到我备份那天的!为什么????
- 急!!!关于INSERT语句
- 頭痛的 String or binary data would be truncated 錯誤
- 登录程序的编制?
- 有熟SQL sever7的吗?帮哦看一下
- 求SQL函数
- Windowsxp可以安装sql server2005吗
into test3 From test Where F_DealDate is not null
group by F_Name, F_Key
into test3 From test Where F_DealDate is not null
group by F_Name, F_Key
Select Count(1) dealQty, F_Name, F_Key,cast(0 as dec(28,2)) as edrPOSQty
into test3 From test Where F_DealDate is not null
group by F_Name, F_Key