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 |
优质生活从拆开始
分类:
SQL / MSSQL
标签:
SQL
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2022-08-24 EBS: 触发器三种状态(INSERTING, UPDATING , DELETING )实例