91在线无码精品秘 蜜桃,先锋资源羞羞视频一区二区,www.hzyhfdc.com,午夜精品BBBBB免费人妻

邦永&中国™å¹ç›®½Ž¡ç†

上一½‹?/a>目录下一½‹?/a>

常è§é—®é¢˜?sh¨´)¸Žåˆ†æ?/div>

      一ã€å‚数设¾|?/h3>

       1.1ã€èœå•ä½¾|?/span>

业务表å•-åŽå°½Ž¡ç†-函数å‚数定义

1.2ã€æ–°å¢žå‚æ•?/span>

 åˆ—表½H—体

新增å‚æ•°

å‚æ•°½Ž€¿UŽÍ¼š(x¨¬)

æ ¼å¼åQšå‰¾~€[å‚æ•°½Ž€¿U°]

其中“剾~€â€å¿…™åÖMØ“(f¨´) PM2,且è¦å¤§å†™åQŒâ€å‚数简¿U°â€œåˆ™è¦ç¬¦åˆæ­£åˆ™è¡¨è¾‘ּ字符,且用中括åäh‹¬èµäh¥åQŒå¦åˆ™æ— æ•ˆã€?/p>

用例åQ?nbsp;PM2[Name]

å‚æ•°å«ä¹‰åQ?/p>

ç›®å‰æœ‰ä»¥ä¸‹å‚æ•°å¯ä¾›é€‰æ‹©åQŒå³å–当å‰PM2用户的具体å€?/p>

      二ã€è‡ªç”±æŠ¥è¡¨è„šæœ¬å¼•ç”¨å®žä¾?/h3>

昄¡¤ºå½“å‰ç”¨æˆ·æœ‰æƒé™çš„™å¹ç›®æ•°æ®

SQL脚本如下åQ?/p>

Select * from sdpa001 Where pa00101 in (select ps01303 from sdvw_GetXmRight where

 pj00602='PM2[Name]' and ps01302 in(2,7) and ps01306 in(1,2))

其中PM2[Name],ž®±æ˜¯å–å‚æ•îC¸­è®„¡½®çš„å‚数简¿UŽÍ¼Œå€¼å°†è‡ªåŠ¨å–对应的å‚æ•°å«ä¹‰å€¹{€?/p>

é…ïL(f¨¥ng)‰¹æŠ¥è¡¨ä¸¾ä¾‹

å¯ä»¥é€šè¿‡æŸ¥çœ‹è„šæœ¬åQŒç¼–辑原脚本åQŒç„¶åŽæ›´æ–°è„šæœ¬å³å¯ã€?/p>

Select * from sdpa508_view

where proId in (select ps01303 from sdvw_GetXmRight where

 pj00602='PM2[Name]' and ps01302 in(2,7) and ps01306 in(1,2))

 

关闭
91在线无码精品秘 蜜桃,先锋资源羞羞视频一区二区,www.hzyhfdc.com,午夜精品BBBBB免费人妻