Advertisement
Guest User

Правило поиска дублей: регистрация правила

a guest
Jul 7th, 2020
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. DECLARE @AccountUId UNIQUEIDENTIFIER;
  2.  
  3. Set @AccountUId = (SELECT TOP 1 SysSchema.UId FROM SysSchema
  4. WHERE SysSchema.Name = 'Account' AND SysSchema.ExtendParent = 0);
  5.  
  6. INSERT INTO DuplicatesRule ([IsActive], [ObjectId], [ProcedureName], [Name], [UseAtSave]) VALUES
  7.   (1, @AccountUId, 'tsp_FindAccountDuplicateByInfTIN', N'Дубли контрагентов. ИНН', 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement