1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
CREATE PROCEDURE [xxx].[dt_xxxxxxxxxxx] AS
set nocount on
SET DATEFORMAT ymd
/*Déclaration des variables utilisées */
DECLARE @logFileName varchar(254)
DECLARE @logSoftware varchar(254)
DECLARE @logCompany varchar(64)
DECLARE @logProduct varchar(64)
DECLARE @logDate varchar(32)
DECLARE @logVersion varchar(32)
DECLARE @logOriginalFileName varchar(32)
DECLARE @logLangID varchar(10)
DECLARE @valider int
DECLARE @cptCommit int
/* Déclaration du curseur pour xxxxx */
DECLARE C_listeLogiciel CURSOR
FAST_FORWARD
READ_ONLY
FOR
SELECT FILENAME, SOFTWARE, COMPANYNAME, PRODUCTNAME, DATETIME, FILEVERSION, ORIGINALFILENAME, LANG_ID
FROM xxxxx
OPEN C_listeLogiciel
FETCH NEXT FROM C_listeLogiciel INTO @logFileName, @logSoftware, @logCompany, @logProduct, @logDate, @logVersion, @logOriginalFileName, @logLangID
SET @cptCommit = 0
BEGIN TRANSACTION
/* Boucle qui parcours tout les enregistrements de xxxxx */
WHILE @@FETCH_STATUS = 0
BEGIN
SET @cptCommit = @cptCommit + 1
SET @logSoftware = replace(@logSoftware, "'", "''")
SET @logCompany = replace(@logCompany, "'", "''")
SET @logProduct = replace(@logProduct, "'", "''") |
Partager