{"id":2338,"date":"2012-11-09T04:14:37","date_gmt":"2012-11-09T04:14:37","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2338"},"modified":"2012-11-09T04:14:37","modified_gmt":"2012-11-09T04:14:37","slug":"sqlserver%e6%9f%a5%e7%9c%8b%e6%9d%83%e9%99%90","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/11\/09\/sqlserver%e6%9f%a5%e7%9c%8b%e6%9d%83%e9%99%90\/","title":{"rendered":"SQLSERVER\u67e5\u770b\u6743\u9650"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--\u67e5\u770b\u5f53\u524d\u5e93\u7684\u8d26\u53f7\r\n\r\nSELECT  members.name, roles.name,roles.type_desc,members.type_desc\r\nFROM sys.database_role_members rolemem\r\nINNER JOIN sys.database_principals roles\r\nON rolemem.role_principal_id = roles.principal_id\r\nINNER JOIN sys.database_principals members\r\nON rolemem.member_principal_id = members.principal_id\r\nORDER BY members.name\r\n\r\nEXEC dbo.sp_helprolemember\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u67e5\u770b\u5f53\u524d\u5e93\u7684\u8d26\u53f7 SELECT members.name, roles.name,roles.type_d [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2338","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2338"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2338\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}