摘要:
在Sql Manage Studio中,按住Ctrl键,再右键选择小钥匙,就可以设置多个主键(比两个多多少?不懂) 阅读全文
摘要:
select ID,Name,Description,max(TheRight) as TheRight from( SELECTdbo.b_ApplicationModule.ID, dbo.b_ApplicationModule.Name,dbo.b_ApplicationModule.Description, dbo.b_RoleRight.TheRight AS TheRight FROMdbo.b_ApplicationModule LEFT OUTER JOIN dbo.b_RoleRight ON dbo.b_ApplicationModule.ID = dbo.b_RoleRi 阅读全文