View Code
CREATE
PROCEDURE
addusermodule
@ModuleId_Array
varChar
(
2000
),
@UserId
int
AS
DECLARE
@PointerPrev
int
DECLARE
@PointerCurr
int
DECLARE
@TId
int
Set
@PointerPrev
=
1
set
@PointerCurr
=
1
begin
transaction
Set
NoCount
ON
delete
from
tests
where
userid
=
@UserId
Set
@PointerCurr
=
CharIndex
(
'
,
'
,
@ModuleId_Array
,
@PointerPrev
+
1
)
set
@TId
=
cast
(
SUBSTRING
(
@ModuleId_Array
,
@PointerPrev
,
@PointerCurr
-
@PointerPrev
)
as
int
)
Insert
into
tests (userid,moduleid)
Values
(
@UserId
,
@TId
)
SET
@PointerPrev
=
@PointerCurr
while
(
@PointerPrev
+
1
<
LEN
(
@ModuleId_Array
))
Begin
Set
@PointerCurr
=
CharIndex
(
'
,
'
,
@ModuleId_Array
,
@PointerPrev
+
1
)
if
(
@PointerCurr
>
0
)
Begin
set
@TId
=
cast
(
SUBSTRING
(
@ModuleId_Array
,
@PointerPrev
+
1
,
@PointerCurr
-
@PointerPrev
-
1
)
as
int
)
Insert
into
tests (userid,moduleid)
Values
(
@UserId
,
@TId
)
SET
@PointerPrev
=
@PointerCurr
End
else
Break
End
set
@TId
=
cast
(
SUBSTRING
(
@ModuleId_Array
,
@PointerPrev
+
1
,
LEN
(
@ModuleId_Array
)
-
@PointerPrev
)
as
int
)
Insert
into
tests (userid,moduleid)
Values
(
@UserId
,
@TId
)
delete
from
tests
where
moduleid
=
0
Set
NoCount
OFF
if
@@error
=
0
begin
commit
transaction
end
else
begin
rollback
transaction
end
GO
編輯器加載中...
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
