我search了一下在线名单,知道你还在哦!yoki(小马哥)你帮了我大忙了~~!!
解决方案 »
- 关于权限的一个问题
- 使用insert into语句插入记录时,如何保证插入的记录不重复
- sql语句问题
- MSSQL 大师们,帮助解释一下,关于表扫描后的参数指标说。(MSSQL 性能优化之一)
- 在SQL中,打开表,返回所有行时,提示:无法执行查询,因为一些文件缺少或未注册。再次运行安装程序确保要求的文件已注册?
- SQL同一列同一行中的数据合并
- sql 2005 在多核CPU的服务器上 总是只是用其中某几个CPU而其他CPU处于闲置状态
- 号码反选
- Installshield 打包 sql脚本 出错
- XP_CMDSHELL调用VBS
- 可用分的50%用于寻求问题的解法!将SQL语句转换成ASP的语句!操作对象是ACCESS数据库。高手帮忙!
- 再线等待,各位大侠请了
<%
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd"conn.Open strconn
set cmd.ActiveNonnection=conncmd.CommandText="{call nono}"''set rs=cmc.exe 或者cmd.executeset rs=cmd.Execute()%>
2,一个输入的参数的存储过程
<%
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd"conn.Open strconn
set cmd.ActiveConnection=conncmd.CommandText="{call oneinput(?)}"
cmd.Parameters.Append cmd.CreateParameter("@aaa",adInteger ,adParamInput )
cmd("@aaa")=100cmd.Execute()%>
3,一个输入参数和一个输出的参数
<%
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd"conn.Open strconn
set cmd.ActiveConnection=conncmd.CommandText = "{call oneinout(?,?)}"
cmd.Parameters.Append cmd.CreateParameter("@aaa",adInteger,adParamInput)
cmd("@aaa")=10
cmd.Parameters.Append cmd.CreateParameter("@bbb",adInteger,adParamOutput)cmd.Execute()bbb=cmd("@bbb")
%>
4,一个输入参数,一个输出参数,和一个返回值
<%
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd"conn.Open strconn
set cmd.ActiveConnection=conncmd.CommandText="{?=call onereturn(?,?)}"cmd.Parameters.Append cmd.CreateParameter("@return_value",adInteger,adParamReturnValue )
cmd.Parameters.Append cmd.CreateParameter("@aaa",adInteger,adParamInput )
cmd("@aaa")=10
cmd.Parameters.Append cmd.CreateParameter("@bbb",adInteger,adParamOutput)cmd.Execute()bbb=cmd("@bbb")
rrr=cmd("@return_value")
%>
begin
select (select xingming from jiben where xuehao=a.xuehao) 学生姓名,(select kecheng from kecheng where ID=a.ID) 课程名称,fenshu into #temp from chengji a
declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then fenshu else 0 end) '+课程名称 from (select distinct 课程名称 from #temp) as a
exec(@sql+' from #temp group by 学生姓名')
go
begin
select (select xingming from jiben where xuehao=a.xuehao) 学生姓名,(select kecheng from kecheng where ID=a.ID) 课程名称,fenshu into #temp from chengji a
declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then fenshu else 0 end) '+课程名称 from (select distinct 课程名称 from #temp) as a
exec(@sql+' from #temp group by 学生姓名')
end
go
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd"conn.Open strconn
set cmd.ActiveNonnection=conncmd.CommandText="{call 过程名}"''set rs=cmc.exe 或者cmd.executeset rs=cmd.Execute()%>
select (select 姓名 from 学生表 where 学号=a.学号) as 学生姓名,
(select 课程名称 from 课程表 where 课程号=a.课程号) as 课程名称,
分数
into #temp
from 成绩表 a declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then 分数 else 0 end) as '+课程名称
from (select distinct 课程名称 from #temp) as a
select @sql=@sql+' from #temp group by 学生姓名'
exec(@sql)
drop table #temp我现在想把字段名和别名区别开来,这样我才能用,因为我的数据库的字段是拼音。不是我不爱学习,也不是我懒惰,
(select 课程名称 from 课程表 where 课程号=a.课程号) as 课程名称,
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then 分数 else 0 end) as '+课程名称我不知道哪个是字段,哪个是别名,明白我的意思?
as '+课程名称
字段的别名
递归
declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then fenshu else 0 end) '+课程名称 from (select distinct 课程名称 from #temp) as a
exec(@sql+' from #temp group by 学生姓名')
-------这个肯定是字段名 ------------这个我知道是别名select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then 分数 else 0 end)
-------???? ?????as '+课程名称
--------??
from (select distinct 课程名称 from #temp) as a
-------???大哥,不如把字段名写成拼音,别名写成“课程课程”
行不?
/asp/xsgl/quest4.asp, 第 46 行, 第 7 列
select (select xingming from jiben where xuehao=a.xuehao) 学生姓名,(select kecheng from kecheng where ID=a.ID) 课程名称,fenshu into #temp from chengji a
---------------------------------------------------------------------^
???????????????????????.ID=a.id
declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then fenshu else 0 end) '+课程名称 from (select distinct 课程名称 from #temp) as a
set rs=newconn.execute(@sql+' from #temp group by 学生姓名')看看是什么原因引起的错误?
select (select xingming from jiben where xuehao=a.xuehao) as 学生姓名,
(select kecheng from kecheng where ID=a.ID) as 课程名称,
fenshu
into #temp
from chengji a declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then 分数 else 0 end) as '+课程名称
from (select distinct 课程名称 from #temp) as a
select @sql=@sql+' from #temp group by 学生姓名'
exec(@sql)
drop table #temp
declare @sql varchar(8000)
set @sql='select xingming'
select @sql=@sql+',sum(case kecheng when '''+kecheng+''' then fenshu else 0 end) '+kecheng from (select distinct kecheng from #temp) as a
exec(@sql+' from #temp group by xingming')
declare @sql varchar(8000)
set @sql='select xingming'
select @sql=@sql+',sum(case kecheng when '''+kecheng+''' then fenshu else 0 end) '+kecheng
from (select distinct kecheng from #temp) as aexec(@sql+' from #temp group by xingming')
(select kecheng from kecheng where kecheng.ID=a.ID) as 课程名称,
fenshu
into #temp
from chengji a declare @sql varchar(8000)
set @sql='select 学生姓名'
select @sql=@sql+',sum(case 课程名称 when '''+课程名称+''' then 分数 else 0 end) as '+课程名称
from (select distinct 课程名称 from #temp) as a
select @sql=@sql+' from #temp group by 学生姓名'
set rs=newconn.execute(@sql)
drop table #temp
错误:
Microsoft VBScript 编译器错误 (0x800A03FD)
/asp/xsgl/quest4.asp, 第 46 行, 第 7 列
select (select xingming from jiben where jiben.xuehao=a.xuehao) as 学生姓名,
----------------------------------------------^
set @sql='select xingming'
select @sql=@sql+',sum(case kecheng when '''+kecheng+''' then fenshu else 0 end) '+kecheng
from (select distinct kecheng from #temp) as aexec(@sql+' from #temp group by xingming')
select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,
(select kecheng from kecheng where ID=a.ID) as C_NAME,
fenshu
into #temp
from chengji a declare @sql varchar(8000)
set @sql='select S_NAME'
select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME
from (select distinct C_NAME from #temp) as a
select @sql=@sql+' from #temp group by S_NAME'
exec(@sql)
drop table #temp
/asp/xsgl/quest4.asp, 第 43 行, 第 7 列
select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,(select kecheng from kecheng where ID=a.ID) as C_NAME,fenshu into #temp from chengji a
----------------------------------------------------------------------^
Dim strSql As String
strSql = " select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,"
strSql = strSql + " (select kecheng from kecheng where ID=a.ID) as C_NAME,fenshu"
strSql = strSql + " into #temp from chengji a"
strSql = strSql + " declare @sql varchar(8000)"
strSql = strSql + " set @sql='select S_NAME'"
strSql = strSql + " select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME"
strSql = strSql + " from (select distinct C_NAME from #temp) as a"
strSql = strSql + " select @sql=@sql+' from #temp group by S_NAME'"
Set rs = newconn.Execute(strSql)
newconn.Execute " drop table #temp"
(select kecheng from kecheng where ID=a.ID) as C_NAME,
fenshu
into #temp
from chengji a
where banhao='你输入的班号'declare @sql varchar(8000)
set @sql='select S_NAME'
select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME
from (select distinct C_NAME from #temp) as a
select @sql=@sql+' from #temp group by S_NAME'
exec(@sql)
drop table #temp
strSql = " select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,"
strSql = strSql + " (select kecheng from kecheng where ID=a.ID) as C_NAME,fenshu"
strSql = strSql + " into #temp from chengji a"
strSql = strSql + " declare @sql varchar(8000)"
strSql = strSql + " set @sql='select S_NAME'"
strSql = strSql + " select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME"
strSql = strSql + " from (select distinct C_NAME from #temp) as a"
strSql = strSql + " select @sql=@sql+' from #temp group by S_NAME'"
response.Write strSql
' Set rs=newconn.Execute(strSql)
' newconn.Execute " drop table #temp"response.Write("ok")执行结果:
here select (select xingming from jiben where xuehao=a.xuehao) as S_NAME, (select kecheng from kecheng where ID=a.ID) as C_NAME,fenshu into #temp from chengji a declare @sql varchar(8000) set @sql='select S_NAME' select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME from (select distinct C_NAME from #temp) as a select @sql=@sql+' from #temp group by S_NAME'ok
Set rs=newconn.Execute(strSql)错误。类型:同上
这个都在strsql里面,如何执行??
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
/asp/xsgl/quest4.asp, 第 53 行应该都是select 什么的语句吧。。
newconn.execute(sql)
newconn.execute("drop table #temp")中间一句报错。。
declare @sql varchar(8000)
set @sql='select S_NAME'
select @sql=@sql+',sum(case A when '''+C_NAME+''' then fenshu else 0 end) as '+C_NAME
from (select distinct C_NAME from (select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,
(select kecheng from kecheng where ID=a.ID) as C_NAME,
fenshu
from chengji a
where banhao='你输入的班号')t) as a
select @sql=@sql+' from (select (select xingming from jiben where xuehao=a.xuehao) as S_NAME,
(select kecheng from kecheng where ID=a.ID) as C_NAME,
fenshu
from chengji a
where banhao=你输入的班号)t group by S_NAME'
exec(@sql)
@sql 我回来慢慢研究,要吃饭去了,sql="" 不能用' '
郁闷中
http://expert.csdn.net/Expert/topic/1711/1711580.xml?temp=9.481448E-02
这个问题。问题解决了,这100分就是你的。