{"id":2967,"date":"2014-01-19T02:39:23","date_gmt":"2014-01-19T02:39:23","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2967"},"modified":"2014-05-17T06:32:19","modified_gmt":"2014-05-17T06:32:19","slug":"%e5%af%b9%e8%b1%a1%e4%be%9d%e8%b5%96%e5%85%b3%e7%b3%bb%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2014\/01\/19\/%e5%af%b9%e8%b1%a1%e4%be%9d%e8%b5%96%e5%85%b3%e7%b3%bb%e6%9f%a5%e8%af%a2\/","title":{"rendered":"\u5bf9\u8c61\u4f9d\u8d56\u5173\u7cfb\u67e5\u8be2"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--\u67e5\u8be2\u6307\u5b9a\u5bf9\u8c61\u5f15\u7528\u7684\u5bf9\u8c61\u6216\u5217\uff0c\u5982\u5b58\u50a8\u8fc7\u7a0b\u5f15\u7528\u7684\u8868\r\nSELECT OBJECT_NAME(referencing_id) AS referencing_entity_name, \r\n    o.type_desc AS referencing_desciption, \r\n    COALESCE(COL_NAME(referencing_id, referencing_minor_id), &#39;(n\/a)&#39;) AS referencing_minor_id, \r\n    referencing_class_desc,\r\n    referenced_server_name, referenced_database_name, referenced_schema_name,\r\n    referenced_entity_name, \r\n    COALESCE(COL_NAME(referenced_id, referenced_minor_id), &#39;(n\/a)&#39;) AS referenced_column_name,\r\n    is_caller_dependent, is_ambiguous\r\nFROM sys.sql_expression_dependencies AS sed\r\nINNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id\r\nWHERE referencing_id = OBJECT_ID(N&#39;bdorder_sel&#39;);\r\n\r\n--\u67e5\u8be2\u5f15\u7528\u6307\u5b9a\u5bf9\u8c61\u7684\u5bf9\u8c61\uff0c\u5982\u5f15\u7528\u67d0\u8868\u7684\u5b58\u50a8\u8fc7\u7a0b\r\nSELECT OBJECT_SCHEMA_NAME ( referencing_id ) AS referencing_schema_name,\r\n    OBJECT_NAME(referencing_id) AS referencing_entity_name, \r\n    o.type_desc AS referencing_desciption, \r\n    COALESCE(COL_NAME(referencing_id, referencing_minor_id), &#39;(n\/a)&#39;) AS referencing_minor_id, \r\n    referencing_class_desc, referenced_class_desc,\r\n    referenced_server_name, referenced_database_name, referenced_schema_name,\r\n    referenced_entity_name, \r\n    COALESCE(COL_NAME(referenced_id, referenced_minor_id), &#39;(n\/a)&#39;) AS referenced_column_name,\r\n    is_caller_dependent, is_ambiguous\r\nFROM sys.sql_expression_dependencies AS sed\r\nINNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id\r\nWHERE referenced_id = OBJECT_ID(N&#39;dbo.bdorder&#39;);\r\n\r\n\r\n--\u67e5\u8be2\u5f15\u7528\u5176\u5b83\u6570\u636e\u5e93\u7684\u5bf9\u8c61,\u8fde\u63a5\u670d\u52a1\u5668\r\n<\/pre>\n<div>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\nSELECT OBJECT_NAME (referencing_id),referenced_server_name,referenced_database_name,<\/pre>\n<\/div>\n<div>\n\t&nbsp; &nbsp; referenced_schema_name, referenced_entity_name<\/div>\n<div>\n\tFROM sys.sql_expression_dependencies<\/div>\n<div>\n\tWHERE referenced_database_name =&#39;OA&#39; AND referenced_server_name=&#39;172.16.88.231&#39;<\/div>\n<p><a href=\"http:\/\/msdn.microsoft.com\/query\/dev10.query?appId=Dev10IDEF1&amp;l=ZH-CN&amp;k=k(SQL_EXPRESSION_DEPENDENCIES_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&amp;rd=true\">sys.sql_expression_dependencies<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u67e5\u8be2\u6307\u5b9a\u5bf9\u8c61\u5f15\u7528\u7684\u5bf9\u8c61\u6216\u5217\uff0c\u5982\u5b58\u50a8\u8fc7\u7a0b\u5f15\u7528\u7684\u8868 SELECT OBJECT_NAME(referencin [&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-2967","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\/2967","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=2967"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2967\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}