{"id":588,"date":"2010-10-01T07:43:59","date_gmt":"2010-10-01T07:43:59","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=588"},"modified":"2010-10-01T07:43:59","modified_gmt":"2010-10-01T07:43:59","slug":"set-null%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/10\/01\/set-null%e6%93%8d%e4%bd%9c\/","title":{"rendered":"set null\u64cd\u4f5c"},"content":{"rendered":"<pre lang=\"csharp\">\r\ndeclare @salesstaff varchar(50)\r\nset @salesstaff = null\r\nSELECT @SalesStaff = SalesStaff FROM bdCustomerAllocate WHERE Departmentid = 4 AND CustomerID = -111\r\nif ( @salesstaff  is   null )\r\nbegin\r\n    print 'null'\r\nend\r\nelse\r\nbegin\r\n    print 'sdf'\r\nend\r\n<\/pre>\n<p>\u82e5\u6570\u636e\u5e93\u4e2d\u6ca1\u6709\u6b64\u8bb0\u5f55\uff0c\u5219\u4e0d\u4f1a\u7ed9 @SalesStaff\u8d4b\u503c\uff0c\u5b83\u4f1a\u4fdd\u7559\u539f\u503c\uff0c\u6545\u6700\u597d\u5728\u8d4b\u503c\u524d\u5c06\u5176\u8bbe\u4e3aNULL<\/p>\n","protected":false},"excerpt":{"rendered":"<p>declare @salesstaff varchar(50) set @salesstaff = null  [&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-588","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\/588","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=588"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/588\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}