SQL="DECLARE @vBusinessType NVARCHAR(4000)" _
&" SET @vBusinessType='TEST'" _
&" SELECT * FROM TABLE_A" _
&" WHERE TABLE_A.BUSINESS_TYPE LIKE @vBusinessType" _
&" GROUP BY TABLE_A.BUSINESS_TYPE" _
set rs=Server.CreateObject("adodb.recordset")
rs.Open SQLstr, Conn,adOpenStatic ,adLockPessimistic
rs.Save Response, adPersistXML执行到rs.save时报错“对象关闭时,不允许操作”奇怪的是,去掉SET @vBusinessType='TEST'以后,rs能够返回数据。
&" SET @vBusinessType='TEST'" _
&" SELECT * FROM TABLE_A" _
&" WHERE TABLE_A.BUSINESS_TYPE LIKE @vBusinessType" _
&" GROUP BY TABLE_A.BUSINESS_TYPE" _
set rs=Server.CreateObject("adodb.recordset")
rs.Open SQLstr, Conn,adOpenStatic ,adLockPessimistic
rs.Save Response, adPersistXML执行到rs.save时报错“对象关闭时,不允许操作”奇怪的是,去掉SET @vBusinessType='TEST'以后,rs能够返回数据。
1、SQL server 2000
2、ASP
SQL=" SELECT * FROM TABLE_A" _
&" WHERE TABLE_A.BUSINESS_TYPE LIKE '%TEST%'" _
&" GROUP BY TABLE_A.BUSINESS_TYPE"
结果为 returnvalue=0 numcount=1如果要使用局部变量 请写在存储过程中
GROUP BY TABLE_A.BUSINESS_TYPE在 sql2000 group by TABLE_A.BUSINESS_TYPE 可以这样写?