34,593
社区成员
发帖
与我相关
我的任务
分享
<%
Set Cmd_1 = Server.CreateObject("ADODB.Command")
Set Cmd_1.ActiveConnection=conn
Cmd_1.CommandText="textsum"
Cmd_1.CommandType=4
CMD_1.Prepared = true
Cmd_1.Parameters.Append cmd_1.CreateParameter("@sum_number",200,2,50)
Cmd_1.Parameters.Append cmd_1.CreateParameter("@sum_totalprice",200,2,50)
Set rs_1=Cmd_1.Execute
sum_number=cmd_1("@sum_number")
sum_totalprice=cmd_1("@sum_totalprice")
set Cmd_1 = nothing
%>
USE [数据库名]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[testsum]
@sum_number int output,
@sum_totalprice numeric(18,1) output
AS
BEGIN
SELECT sum(number) as @sum_number,sum(totalprice) as @sum_totalprice FROM 表
END
USE [数据库名]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[testsum]
@sum_number int output,
@sum_totalprice numeric(18,1) output
AS
BEGIN
SELECT sum(number) as sum_number,sum(totalprice) as sum_totalprice FROM 表
END
set @sum_number=1
set @sum_totalprice=2
请问怎么把select sum(number)as sum_number这里面的sum_number赋值给@sum_number咧?USE [数据库名]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[testsum]
@sum_number int output,
@sum_totalprice numeric(18,1) output
AS
BEGIN
SELECT sum(@sum_number) as number,sum(@sum_totalprice) as totalprice FROM 表
END
怎么似乎跟ASP中写的SQL反过来了。
不应该是select sum(列名) as 变量 from 表的样子么……