摘要:
在Sql Manage Studio中,按住Ctrl键,再右键选择小钥匙,就可以设置多个主键(比两个多多少?不懂)
阅读全文
posted @ 2013-01-12 12:29
DearBug
阅读(518)
推荐(0)
编辑
摘要:
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
阅读全文
posted @ 2013-01-12 00:40
DearBug
阅读(178)
推荐(0)
编辑