select convert(varchar(10),getdate(),112) result/* result --------- 20080704 */
--大概的思路写下: declare @sql varchar(200)set @sql=' if exists(select 1 from sysobjects where name='v_view' and xtype='v') drop view v_view go create view v_view as select 字段1,(select sum(指定字段) from 交易''+日期+'' where 条件) as 字段2,...,字段n from 交易''+日期+'' group by 字段1,...,字段n'exec(@sql)
select convert(varchar(10),getdate(),112) result/*
result
---------
20080704
*/
declare @sql varchar(200)set @sql='
if exists(select 1 from sysobjects where name='v_view' and xtype='v')
drop view v_view
go
create view v_view
as
select 字段1,(select sum(指定字段) from 交易''+日期+'' where 条件) as 字段2,...,字段n from 交易''+日期+'' group by 字段1,...,字段n'exec(@sql)