SAP 9.2: _TmSp_AliasUpdate_OUSR存储过程 是什么功能呢?

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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
create PROC _TmSp_AliasUpdate_OUSR
WITH ENCRYPTION
AS
----------------------------------------------------------------
INSERT INTO [OUSR]([INTERNAL_K], [PASSWORD], [PASSWORD1], [PASSWORD2], [USERID],
            [USER_CODE], [U_NAME], [GROUPS], [PASSWORD4],
            [ALLOWENCES], [SUPERUSER], [DISCOUNT], [PASSWORD3],
            [Info1File], [Info1Field], [Info2File], [Info2Field],
            [Info3File], [Info3Field], [Info4File], [Info4Field],
            [dType], [E_Mail], [PortNum], [OutOfOffic], [SendEMail],
            [SendSMS])
SELECT [INTERNAL_K], [PASSWORD], [PASSWORD1], [PASSWORD2], [_USER_],
        [USER_CODE], [_U_NAME], [GROUPS], [PASSWORD4],
        [ALLOWENCES], [SUPERUSER], [DISCOUNT], [PASSWORD3],
        [Info1File], [Info1Field], [Info2File], [Info2Field],
        [Info3File], [Info3Field], [Info4File], [Info4Field],
        [dType], [E_Mail], [PortNum], [OutOfOffic], [SendEMail],
        [SendSMS]
FROM TEMP_OUSR
  
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'DfltsGroup')
BEGIN
  exec ('UPDATE OUSR
  SET DfltsGroup = TEMP_OUSR.DfltsGroup
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'CashLimit')
BEGIN
  exec ('UPDATE OUSR
  SET CashLimit = TEMP_OUSR.CashLimit
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'MaxCashSum')
BEGIN
  exec ('UPDATE OUSR
  SET MaxCashSum = TEMP_OUSR.MaxCashSum
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'Fax')
BEGIN
  exec ('UPDATE OUSR
  SET Fax = TEMP_OUSR.Fax
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'SendFax')
BEGIN
  exec ('UPDATE OUSR
  SET SendFax = TEMP_OUSR.SendFax
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'ALLOWENCS1')
BEGIN
  exec ('UPDATE OUSR
  SET ALLOWENCS1 = TEMP_OUSR.ALLOWENCS1
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'Department')
BEGIN
  exec ('UPDATE OUSR
  SET Department = TEMP_OUSR.Department
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K AND
                       NOT TEMP_OUSR.Department is NULL')
END
  
IF  exists (select 1 from syscolumns inner Join
           sysobjects on sysobjects.id = syscolumns.id
           where sysobjects.name = 'TEMP_OUSR' And
           syscolumns.name = 'Branch')
BEGIN
  exec ('UPDATE OUSR
  SET Branch = TEMP_OUSR.Branch
  FROM TEMP_OUSR WHERE OUSR.INTERNAL_K = TEMP_OUSR.INTERNAL_K AND
                       NOT TEMP_OUSR.Branch is NULL'
END
  
DROP TABLE TEMP_OUSR

  

posted @   samrv  阅读(21)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
历史上的今天:
2022-08-24 EBS: 触发器三种状态(INSERTING, UPDATING , DELETING )实例
点击右上角即可分享
微信分享提示