zzz

Sql code posted
created at 09 Sep 08:43

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
 
--Modif de la table [SpecialRights]: ajout dse roles TSAdjustmentRead et TSAdjustmentWrite
ALTER TABLE [Timesheet].dbo.[SpecialRights] 
ADD TSAdjustmentRead bit NOT NULL DEFAULT(0), 
TSAdjustmentWrite bit NOT NULL DEFAULT(0)


--Création synonyme Hours pour lire la table Hours depuis timesheet
USE [Timesheet]
GO

CREATE SYNONYM [dbo].[Hours] FOR [paf_data].[dbo].[Hours]
GO
387 Bytes in 2 ms with coderay