NOTE: A database backup MUST be performed prior to following these steps.
insert into dialogcolumn (UID_DialogColumn, uid_dialogtable, columnname , XObjectKey , XUserInserted, XUserUpdated, XDateInserted, XDateUpdated , SchemaDataType, SchemaDataLen ) select x.UID_DialogColumn, x.UID_DialogTable, x.columnname , dbo.QBM_FCVElementToObjectKey1('DialogColumn', 'UID_DialogColumn', x.UID_DialogColumn) , dbo.QBM_FGIDBOwner(), dbo.QBM_FGIDBOwner(), GetUTCDate(), GetUTCDate() , x.DATA_TYPE, x.CHARACTER_MAXIMUM_LENGTH from ( select -- 33849dbo.QBM_FCVStringToGUID(dbo.QBM_FGIDBOwner(), o.COLUMN_NAME + o.TABLE_NAME + dbo.QBM_FGIDBOwner()) dbo.QBM_FGIUID_DialogColumn (o.TABLE_NAME, o.COLUMN_NAME, null) as UID_DialogColumn, t.UID_DialogTable, rtrim(left(o.COLUMN_NAME,30)) as columnname , o.DATA_TYPE , o.CHARACTER_MAXIMUM_LENGTH from information_schema.columns o join dialogtable t on t.TableName = o.Table_name and o.Column_name not in ( N'msrepl_synctran_ts' , N'msrepl_tran_version' ) and not exists (select top 1 1 from dialogcolumn g where g.UID_DialogTable = t.UID_DialogTable and g.columnname = o.Column_name ) and t.TableType in ('B', 'T') ) as x
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center