--查询有没有@chvTableName_XXXXXX(年代),即@chvFinalTableName表,假如没有则创建
BEGIN
IFNOTEXISTS(SELECT*FROMsysobjectsWHERENAME=@chvFinalTableName1ANDxtype=U)--事务表
BEGIN
SELECT@chrnSQL=CREATETABLE[dbo].[+@chvFinalTableName8+](
+[EVID][char](12)COLLATEChinese_PRC_CI_ASNOTNULL,
+[StarTime][datetime]NOTNULL,
+[StarStake][varchar](9)COLLATEChinese_PRC_CI_ASNOTNULL,
+[EndStake][varchar](9)COLLATEChinese_PRC_CI_ASNOTNULL,
+[Direcation][char](1)COLLATEChinese_PRC_CI_ASNOTNULL,
+[EvType][varchar](3)COLLATEChinese_PRC_CI_ASNOTNULL,
+[EndTime][datetime]NULL,
+[Description][varchar](200)COLLATEChinese_PRC_CI_ASNULL,
+[Advice][varchar](200)COLLATEChinese_PRC_CI_ASNULL,
+[EconLoss][int]NULL,
+[DeathToll][tinyint]NULL,
+CONSTRAINT+@chvFinalTableName8+_PK+PRIMARYKEYCLUSTERED([EVID])ON[PRIMARY]
+)ON[PRIMARY]
EXECsp_ExecuteSql@chrnSQL
END
END;
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
===失掉日期的自界说函数====
SETQUOTED_IDENTIFIERON
GO
SETANSI_NULLSON
GO
ALTERFUNCTIONfnFormatDate_Month(@DATEdatetime)
RETURNSvarchar(50)
AS
BEGIN
declare@intDateYearint,---必要处置数据的年份
@intDateMonthNoint---必要处置数据的月份
declare@chvMonthNovarchar(10),
@chvTableNamevarchar(50)
select@intDateYear=year(@DATE)
select@intDateMonthNo=month(@DATE)select@chvMonthNo=00+convert(varchar(2),@intDateMonthNo)
select@chvMonthNo=substring(@chvMonthNo,len(@chvMonthNo)-1,2
select@chvTableName=convert(varchar(4),@intDateYear)+@chvMonthNo
return(@chvTableName)
END
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
============================================================