ALTER PROCEDURE [dbo].[UP_HourStat_GetMonthSum]
(
@Years int,
@Months int
)
AS
BEGIN
Declare @MonthStr varchar(2000)
Declare @hour int
Declare @sql varchar(2000)select @MonthStr='sum(Hour0)'
select @hour=1
while @hour<24
begin
select @MonthStr=@MonthStr+'+sum(Hour'+CAST(@hour as varchar)+')'
select @hour=@hour+1
end
set @sql='select'+@MonthStr+' as 今月人数 from HourStat where Years='+CONVERT(varchar(20),@Years)+' and Months='+CONVERT(varchar(20),@Months)
exec(@sql)
END上面的报错:第 1 行: 'Hour0' 附近有语法错误。
是什么问题?
(
@Years int,
@Months int
)
AS
BEGIN
Declare @MonthStr varchar(2000)
Declare @hour int
Declare @sql varchar(2000)select @MonthStr='sum(Hour0)'
select @hour=1
while @hour<24
begin
select @MonthStr=@MonthStr+'+sum(Hour'+CAST(@hour as varchar)+')'
select @hour=@hour+1
end
set @sql='select'+@MonthStr+' as 今月人数 from HourStat where Years='+CONVERT(varchar(20),@Years)+' and Months='+CONVERT(varchar(20),@Months)
exec(@sql)
END上面的报错:第 1 行: 'Hour0' 附近有语法错误。
是什么问题?
解决方案 »
- 如何在Login里面添加一个RadioButtonList1控件,然后在后台代码里面判断RadioButtonList1的选项是什么呢??
- 有人用過ASPxGrid控件嗎?里面的GetFieldValueInItem怎么來的?謝謝~
- 超链接,表格问题
- [HELP] advanced 2000 server 英文版用fso操作文件问题!!!!
- 如何在服务器段获取同名checkbox组里面所有checkbox的value?
- 在线等,关于datagrid控件的分页问题
- 一般在什么情况下要使用接口?
- 无法将类型“System.Drawing.Color”隐式转换为“string”
- 如何动态添加控件的事件?
- 高手相助,有没有把日期转化为天数的函数,用c#
- 急!
- asp.net打开本地exe文件
(
@Years int,
@Months int
)
AS
BEGIN
Declare @MonthStr varchar(2000)
Declare @hour int
Declare @sql varchar(2000)select @MonthStr='sum(Hour0)'
select @hour=1
while @hour<24
begin
select @MonthStr=@MonthStr+'+sum(Hour'+CAST(@hour as varchar)+')'
select @hour=@hour+1
end
set @sql='select '+@MonthStr+' as 今月人数 from HourStat where Years='+CONVERT(varchar(20),@Years)+' and Months='+CONVERT(varchar(20),@Months)
exec(@sql)
END
set @sql='select '+@MonthStr+' as 今月人数 from HourStat where'select '这里好像少了个空格
select 后面需要一个空格。set @sql='select '+@MonthStr+' as 今月人数 from HourStat where
set @Months=10Declare @MonthStr varchar(2000)
Declare @hour int
Declare @sql nvarchar(2000)set @MonthStr='sum(Hour0)'set @hour=1while @hour<24
begin
set @MonthStr=@MonthStr+'+sum(Hour'+CAST(@hour as varchar)+')'
set @hour=@hour+1
end
set @sql='select '+@MonthStr+' as N''今月人数'' from HourStat where Years='''+CONVERT(varchar(20),@Years)+''' and Months='''+CONVERT(varchar(20),@Months)+''''print @sqlselect sum(Hour0)+sum(Hour1)+sum(Hour2)+sum(Hour3)+sum(Hour4)+sum(Hour5)+sum(Hour6)+sum(Hour7)+sum(Hour8)+sum(Hour9)+sum(Hour10)+sum(Hour11)+sum(Hour12)+sum(Hour13)+sum(Hour14)+sum(Hour15)+sum(Hour16)+sum(Hour17)+sum(Hour18)+sum(Hour19)+sum(Hour20)+sum(Hour21)+sum(Hour22)+sum(Hour23) as N'????' from HourStat where Years='2005' and Months='10'