SQL创建轨迹表 存储过程

USE [TopDB_Track]
GO
/****** Object:  StoredProcedure [dbo].[spSys_CreateDeviceDataTable]    Script Date: 03/22/2017 16:31:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[spSys_CreateDeviceDataTable] 
  @TrackDate varchar(8)
AS
BEGIN
    --每天创建轨迹表,如果有相同名称的表存在,则报错
declare @TableName varchar(30)
DECLARE @YEAR VARCHAR(4)
DECLARE @MONTH VARCHAR(2)
DECLARE @DATE VARCHAR(2)
declare @SqlStr varchar(8000)
declare @Date_End varchar(20)
set @TableName = 'biz_DevData_'+@TrackDate