In fact, it's easy. SQL Server stored procedures and triggers

1. Declaration and use of variables

DECLARE @var as varchar (50)

Set var= ' ABCD '

2. If loop

If IsNull (@prjid, 0) =0
Begin
print ' did not find prjid!!! ‘
Return
End
Else

Begin

--You must write some code here, otherwise you will get an error.

End

3, the use of cursors

1. DECLARE CURJD cursor for
2. Select Id,fzbh from _tzk
3. Open CURJD
4. FETCH NEXT from CURJD to @jdID, @paperno
6. While @ @FETCH_STATUS =0
7. BEGIN
8. --Here are some handling code
11. FETCH NEXT from CURJD to @jdID, @paperno
12. END
14. Close CURJD
15. Deallocate CURJD

4, the use of triggers

The key is the use of inserted tables and deleted tables

2. ALTER TRIGGER Roleinsert on [dbo]. [RoleName]
4. After INSERT
6. As
8. Declare @RoleID as bigint
10. Set @RoleID = (select Roleid from inserted)
14. Insert into Rolerule (ROLEID,MENUID,PW)
16. Select @roleid, MenuID,0 from menus where menus. MenuID
18. (select MenuID from Rolerule where Role[email protected])
22. Update Rolerule set pw=1 where MenuID in (select MenuID from menus where always=1)
24. and Roleid in (select Roleid from inserted)

And then with these few examples, the other is a process of proficiency.

In fact, it's easy. SQL Server stored procedures and triggers