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
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