Now have three tables, one is the permissions list, access tables have permissions field, if the content of this field is zero access the first table, if the content of this field is 1 visit to the second table

CodePudding user response:

 
Declare @ IsValue varchar (100)='

Select @ IsValue=https://bbs.csdn.net/topics/isnull ([field name], ' ') from [permissions table] 

If @ IsValue! 
=' 'The begin 
- dosometing 
End 
The else 
The begin 
- dosometing 
End