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
| use SIMASS_Journaliere
set language us_english
SET NOCOUNT ON
DECLARE @FileName VARCHAR(50)
DECLARE @SQLCmd VARCHAR(2048)
DECLARE @cmd NVARCHAR(2048)
DECLARE @tableName NVARCHAR(2048)
DECLARE @outPath NVARCHAR(2048)
SET @outPath = 'D:\Temp\Fichiers_Journaliers_test\'
DECLARE tableCursor CURSOR FOR
SELECT [name] FROM sysobjects WHERE type='U'
FOR READ ONLY
OPEN tableCursor
FETCH NEXT FROM tableCursor INTO @tableName
print @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
if ( (DATEPART(hour, getdate()) >= 06) AND (DATEPART(hour, getdate()) < 12))
begin
insert into "BD_Periodes_journee.dbo." + @tableName
SELECT * FROM "Journaliere.dbo." + @tableName
WHERE (DATEPART(day, _DateMiseAjour)) = (DATEPART(day, getdate())) and (DATEPART(hour, _DateMiseAjour) >= 06) AND (DATEPART(hour, _DateMiseAjour) < 12)
SELECT @FileName = '_12h.XML'
SELECT @SQLCmd = 'bcp ' + db_name() + '..' + @tableName + ' FOR XML PATH(''''), ROOT(''Table''), TYPE, ' + ' out ' + @outPath + @tableName + @FileName + ' -w -T'
EXECUTE master..xp_cmdshell @SQLCmd
end
FETCH NEXT FROM tableCursor INTO @tableName
END
CLOSE tableCursor;
DEALLOCATE tableCursor
truncate table BD_Periodes_journee.dbo.salle
truncate table BD_Periodes_journee.dbo.campus |
Partager