USE [TMPDB]
GO
/****** Object: StoredProcedure [dbo].[SalaryFileUpload] Script Date: 2018/3/29 上午 09:40:44 ******/
SET ANSI_NULLS ON
GO
- Mar 29 Thu 2018 09:44
-
【SQL STORE PROCEDURE】bulk 將檔案內的資料上傳至DB中，並將檔案名
USE [TMPDB]
GO
/****** Object: StoredProcedure [dbo].[SalaryFileUpload] Script Date: 2018/3/29 上午 09:40:44 ******/
SET ANSI_NULLS ON
GO
- Mar 29 Thu 2018 09:31
-
【SQL STORE PROCEDURE】SQL使用規則運算式 regular expressions
--個人戶
--1. 1碼英文+9碼數字
--2. (2碼英文+8碼數字)或(8碼數字+2碼英文)
SELECT IDNO
FROM [Temp].[dbo].[tblTemp]
where 1=1
and ( IDNbr like '[A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
or IDNbr like '[A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
or IDNbr like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][A-Z][A-Z]%')
--1. 1碼英文+9碼數字
--2. (2碼英文+8碼數字)或(8碼數字+2碼英文)
SELECT IDNO
FROM [Temp].[dbo].[tblTemp]
where 1=1
and ( IDNbr like '[A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
or IDNbr like '[A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
or IDNbr like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][A-Z][A-Z]%')
- Mar 12 Mon 2018 15:54
-
【SQL INSERT / INTO】 哪個方法快一點
- Mar 12 Mon 2018 15:39
-
【SQL STORE PROCEDURE】一個欄位帶入多個資料
exec [dbo].[JOB_201610280031] '50F491E9-E0BE-4154-BC62-0B1320ECEC9A'
exec [dbo].[JOB_201610280031] '50F491E9-E0BE-4154-BC62-0B1320ECEC9A;BF4532D1-8E7B-4254-862B-0C35E6A9EF05'
ALTER Proc [dbo].[JOB_201610280031]
(
@Campaign varchar(8000), --原本只設定帶一個資料進來時的變數 uniqueidentifier,
)
exec [dbo].[JOB_201610280031] '50F491E9-E0BE-4154-BC62-0B1320ECEC9A;BF4532D1-8E7B-4254-862B-0C35E6A9EF05'
ALTER Proc [dbo].[JOB_201610280031]
(
@Campaign varchar(8000), --原本只設定帶一個資料進來時的變數 uniqueidentifier,
)
- Mar 12 Mon 2018 15:32
-
【SQL】更新LinkServer資料效能增快
- Feb 05 Mon 2018 15:09
-
【SQL Store Procedure】違反資料行的完整條件約束
- Feb 05 Mon 2018 14:52
-
【SQL Store Procedure】跨SERVER存資料的方式，加快速度
- Feb 01 Thu 2018 14:46
-
【SQL 語法】 左補0
- Jan 30 Tue 2018 10:24
-
【SQL-STORE PROCEDURE】從字串中抽取出一段字串
USE [TempDB]
GO
/****** Object: UserDefinedFunction [dbo].[funSplitToString] Script Date: 2018/1/30 上午 10:27:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: UserDefinedFunction [dbo].[funSplitToString] Script Date: 2018/1/30 上午 10:27:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:15
-
【SQL-STORE PROCEDURE】 STEP 1 找出使用的的mail body內容
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailContent] Script Date: 2018/1/30 上午 10:15:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailContent] Script Date: 2018/1/30 上午 10:15:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:13
-
【SQL-STORE PROCEDURE】 STEP 2 將mail的body內容值[XXX]更換成正確的資料
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailBody] Script Date: 2018/1/30 上午 10:13:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetMailBody] Script Date: 2018/1/30 上午 10:13:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
- Jan 30 Tue 2018 10:11
-
【SQL-STORE PROCEDURE】 判斷使用者的權限
USE [TempDB]
GO
/****** Object: StoredProcedure [dbo].[usp_GetAuthCRM] Script Date: 2018/1/30 上午 10:10:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
GO
/****** Object: StoredProcedure [dbo].[usp_GetAuthCRM] Script Date: 2018/1/30 上午 10:10:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO