select type,vendor,sum(pcs) from table where in_date >='2003/01/01' and in_date<='2003/03/03' group by type,vendor
解决方案 »
- 请教用VB实现自动生成文件的功能
- VB的坐标系设定问题
- 关于多表的操作!
- 目标:将1.exe和2.exe合并成3.exe(要求3.exe的图标可以选择),当运行3.exe时,就同时运行1.exe和2.exe,这个问题还没有实现
- 界面上的简体字写入到繁体数据库下的问题
- SQLServer远程连接,拔号上网后要重启Sqlserver服务才能正常使用
- 不允许程序像IE那样打开多个事例,如何实现??
- 如何网卡禁用和起用
- MSHFlexGrid里,如何为每一行赋一个值,让我知道客户点击那一行对应数据库中的纪录
- 用第三方的打包軟件會出現意想不到的錯誤。想知道是什麼錯誤嗎?請點擊這...
- 用MSChart的一个问题
- 欢迎讨论:简体、繁体同界面显示问题
select type,sum(pcs) from table where in_date >='2003/01/01' and in_date<='2003/03/03' and vendor='YY' group by type
select type,sum(pcs) from table where in_date >=#2003/01/01# and in_date<=#2003/03/03# and vendor='YY' group by type
如用"号会数据自动格式化为sring型来比较!
另有一问题:存储过程如下
CREATE PROCEDURE stock_01
@s_sdate as datetime,
@s_edate as datetime,
@s_vendor as varchar
AS
select type,vendor,sum(pcs) as pcs from table
where in_date >=@s_sdate and in_date<=@s_edate and in_ven=@s_vendor
group type,vendor
GO
在VB中调用时这样写为什么不行??
dim Stadate,Enddate,Vendor as string
gcnn.Execute ("insert into p_table exec stock_01 '" & Stadate & "','" & Enddate & "','" & Vendor & "'") '''调用存储过程
dim Stadate,Enddate,Vendor as string
类型不一致
'" & Stadate & "'
#" & Stadate & "#
select type
from tab_name
where in_date between date1 and date2
group by type
pivot vendor这个sql 生成如下表:
type yy qq ...
----------------------
a1 2 4 ...
b1 3 1 ...
... ... ... ...希望对你有用.
数据库是用的sql server 2000
Dim ldb As ADODB.Connection
Dim lcmd As ADODB.Command
'注意在vb中没有datetime数据类型,可用date类型代替
Dim Stadate,Enddate as Date
Dim Vendor As string
Set ldb = New ADODB.Connection
'主要是注意这个连接字符串,可以改变
ldb.ConnectionString = "provider = sqloledb;" & _
"data source=flashstar;initial catalog= WTQU"
ldb.Properties("User Id").Value = "sa"
ldb.Properties("Password").Value = "sa"
ldb.Open
Set lcmd = New ADODB.Command
Set lcmd.ActiveConnection = ldb
lcmd.CommandText = "stock_01" '存储过程名字
lcmd.CommandType = adCmdStoredProc ‘命令类型
lcmd.Parameters.Refresh
'传递参数
lcmd.Parameters("@s_sdate").Value = Stadate
lcmd.Parameters("@s_edate").Value = Enddate
lcmd.Parameters("@s_vendor").Value = Vendor
lcmd.Execute