{"id":584,"date":"2010-10-01T07:42:00","date_gmt":"2010-10-01T07:42:00","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=584"},"modified":"2010-10-01T07:42:00","modified_gmt":"2010-10-01T07:42:00","slug":"%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e5%8f%82%e6%95%b0","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/10\/01\/%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e5%8f%82%e6%95%b0\/","title":{"rendered":"\u5b58\u50a8\u8fc7\u7a0b\u53c2\u6570"},"content":{"rendered":"<pre lang=\"csharp\">\r\n CREATE                PROCEDURE [dbo].[bdCustomerAllocate_sel]\r\n@TranType varchar(40) = NULL,\r\n@Id int = NULL,\r\n@CustomerID int = NULL,\r\n@OpenDate varchar(20) = NULL,       \/\/\u5728 AS \u4e4b\u524d\u7684\u662f\u5f62\u53c2\uff0c\u5219\u7a0b\u5e8f\u4e2d\u4f20\u503c\uff0c\u7a0b\u5e8f\u4e2d\u4f20\u503c\u4e2a\u6570\u53ef\u5c11\u4e8e\u5f62\u53c2\u4e2a\u6570\uff0c\u524d\u63d0\u662f\u6ca1\u6709\u88ab\u4f20\u7684\u5f62\u53c2\u8981\u8d4b\u503c\uff0c\u5982NULL\r\n\r\nAS\r\nDECLARE @CustoemrName varchar(20)        \/\/\u5728As\u4e4b\u540e\u7528 Declare\u5b9a\u4e49\u53d8\u91cf,\u53ea\u5728\u5b58\u50a8\u8fc7\u7a0b\u5185\u90e8\u4f7f\u7528\uff0c\u4e0d\u662f\u5f62\u53c2\u3002\r\nSET @CustomerName = ''\r\nIF(@TranType = 'personalcustomerlist')\r\nBEGIN\r\n    SELECT a.id, b.CustomerName, b.Address, b.Tel, \r\n    (SELECT TOP 1 FollowDate FROM bdFollowRecord T(nolock)\r\n        WHERE T.AllocateID = a.ID) AS FollowDate\r\n    FROM  bdCustomerAllocate a(NOLOCK)\r\n    JOIN bmdCustomer b(NOLOCK)\r\n    ON a.CustomerID = b.ID    \r\n    WHERE a.IsValid = 1\r\nEND\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>CREATE PROCEDURE [dbo].[bdCustomerAllocate_sel] @TranTy [&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-584","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\/584","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=584"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/584\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}