USE [DB_B]
/****** Object: StoredProcedure [dbo].[SP_Upload_FUZZY] Script Date: 2017/2/18 下午 02:06:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Create date: 20170217
-- Description:
-- EXEC [SP_Upload_FUZZY]
-- a.會設定變動的table為哪些，針對當日新增的table寫入FileControl 控制
-- b.將資料由 DB_A copy DB_B
-- c.將欄位去識別化(useid & username)
-- d.更新FileControl 控制檔
-- =============================================
ALTER PROCEDURE [dbo].[SP_Upload_FUZZY]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @TABLE_NAME nvarchar(100)
DECLARE @SQL nvarchar(max)
DECLARE @IsExist char(1)
DECLARE @IsErrFlag char(1)
DECLARE @spname varchar(50)
DECLARE @ERROR int
DECLARE @ROWCOUNT int
DECLARE @ERROR_MESSAGE nvarchar(4000)
SET @spname='SP_Upload_FUZZY'
SET @IsErrFlag = 'N'
/****** Object: StoredProcedure [dbo].[SP_Upload_FUZZY] Script Date: 2017/2/18 下午 02:06:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Create date: 20170217
-- Description:
-- EXEC [SP_Upload_FUZZY]
-- a.會設定變動的table為哪些，針對當日新增的table寫入FileControl 控制
-- b.將資料由 DB_A copy DB_B
-- c.將欄位去識別化(useid & username)
-- d.更新FileControl 控制檔
-- =============================================
ALTER PROCEDURE [dbo].[SP_Upload_FUZZY]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @TABLE_NAME nvarchar(100)
DECLARE @SQL nvarchar(max)
DECLARE @IsExist char(1)
DECLARE @IsErrFlag char(1)
DECLARE @spname varchar(50)
DECLARE @ERROR int
DECLARE @ROWCOUNT int
DECLARE @ERROR_MESSAGE nvarchar(4000)
SET @spname='SP_Upload_FUZZY'
SET @IsErrFlag = 'N'
