SQL求和表达语句怎么写

Question

set rs=Server.CreateObject("ADODB.Recordset")
if session("level")="1" and qdh="" and SelectCase=""and Kdate="" and Jdate="" and cpmc="" then
sql="Select * from client where id>0 order by id desc"
end if
aa="Select sum(anzhuang) from client "
rs.open sql,Conn,1,1
if rs.RecordCount=0 then
response.write"<p align=center><font color=red>没有记录</font></p>"
else
record=rs.recordcount
aa是执行语句，如何把aa这执行结果显示出来，怎么写代码

或者把AA的执行语句并到SQL执行语句里面，我最终要的目的是查询后，把结果集里面anzhuang字段的值求和，然后显示在页面某个地方。回答满意的追加悬赏。

Answer 1

ALTER PROCEDURE [dbo].[BasicOption_Edit] @BoId int, @UploadFormat nvarchar(50), @UploadMaxSize int, @UploadMark int, @SiteName nvarchar(50), @SiteUrl nvarchar(50), @TemUrl nvarchar(50), @SeoWords nvarchar(100), @PageDesc nvarchar(100), @MessYes int AS BEGIN TRANSACTION UPDATE BasicOption SET UploadFormat=@UploadFormat,UploadMaxSize=@UploadMaxSize,UploadMark=@UploadMark,SiteName=@SiteName,SiteUrl =@SiteUrl , TemUrl=@TemUrl, SeoWords=@SeoWords, PageDesc=@PageDesc,MessYes=@MessYes WHERE BoId=@BoId IF @@ERROR > 0 ROLLBACK TRANSACTION COMMIT TRANSACTION 举个例子吧。

Answer 2

Select sum(anzhuang) from client

这就是一个求和语句啊