{"id":2250,"date":"2012-07-18T04:01:32","date_gmt":"2012-07-18T04:01:32","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2250"},"modified":"2012-08-30T01:12:07","modified_gmt":"2012-08-30T01:12:07","slug":"%e5%9b%ba%e5%ae%9a%e6%95%b0%e4%bd%8d%e9%9a%8f%e6%9c%ba%e6%95%b0%e7%9a%84%e7%94%9f%e6%88%90","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/07\/18\/%e5%9b%ba%e5%ae%9a%e6%95%b0%e4%bd%8d%e9%9a%8f%e6%9c%ba%e6%95%b0%e7%9a%84%e7%94%9f%e6%88%90\/","title":{"rendered":"\u56fa\u5b9a\u6570\u4f4d\u968f\u673a\u6570\u7684\u751f\u6210"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--newid()\u4fdd\u8bc1\u6bcf\u6b21\u90fd\u968f\u673a\r\n--checksum \u8f6c\u6210\u6570\u5b57\uff0c\u53ef\u80fd\u6709\u8d1f\u6570\r\n--rand\u4fdd\u8bc1\u6570\u5b57\u90fd\u662f\u6b63\u6570,\u4e14\u6570\u5b57\u8db3\u591f\u5927\r\n--\u8f6c\u6210bigint\u4fdd\u8bc1\u4e0d\u4f1a\u51fa\u73b0e+,\u79d1\u5b66\u8ba1\u6570\u6cd5\r\n--\u968f\u673a\u6574\u6570 SELECT CHECKSUM(NEWID()) \u8fd4\u56de\u968f\u673a\u65701\u5230n\uff1a abs(CHECKSUM(NEWID()))%n + 1\r\n--\u968f\u673a\u6d6e\u70b9\u6570 rand(CHECKSUM(NEWID()))\r\n--\u968f\u673a\u56fa\u5b9a\u6570\u4f4d\u968f\u673a\u6570\uff1aSELECT LEFT(CONVERT(VARCHAR(20),CONVERT(BIGINT,RAND(CHECKSUM(NEWID())) * 1e+16)) + &#39;0000&#39;,16)\r\n\r\nSELECT TOP 10 LEFT(r + &#39;0000&#39;,16)\r\nFROM sys.all_columns a\r\nCROSS JOIN sys.all_columns b\r\nCROSS APPLY( SELECT CONVERT(VARCHAR(20),CONVERT(BIGINT,RAND(CHECKSUM(NEWID())) * 1e+16)) r )  m\r\n\r\nSELECT TOP 2000 rCode --\u6392\u91cd\r\n&nbsp;FROM\r\n(\r\n&nbsp;&nbsp; &nbsp;SELECT DISTINCT rCode\r\n&nbsp;&nbsp; &nbsp;FROM (\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; SELECT&nbsp; LEFT(r,6) rCode\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; FROM sys.all_columns a\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; CROSS APPLY( SELECT ABS(CHECKSUM(NEWID())) r )&nbsp; m\r\n&nbsp;&nbsp; &nbsp;)M\r\n&nbsp;&nbsp; &nbsp;--WHERE NOT EXISTS( SELECT 1 FROM CouponBasicInfo cbi WHERE cbi.CouponNo = m.CouponNo )\r\n) N\r\n\r\n\u6ce8\u610f\uff1aabs(checksum(newid()))\u4f1a\u51fa\u73b0\u91cd\u590d\uff0c\u89c1\u4e0b\u4f8b\uff1a\r\n&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; --\u6b63\u8d1f\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;22699D09-DBF8-4147-996A-16FF92A5EBFB&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;97293ABF-B3A8-4427-BE65-21F3A92EAE2A&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --\u53cc\u8d1f\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;9F5BE5EA-D4C7-4207-AAB0-046B35795557&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;16A51019-E786-4FDD-B661-8C9353B20053&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --\u53cc\u6b63\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;E60F036B-86FB-48D0-AD09-DB0B7E6091EC&#39;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT CHECKSUM(&#39;9106BB7D-7228-4649-8511-0C96780F1917&#39;)\r\n\u53c2\u8003\uff1ahttp:\/\/www.sqlservercentral.com\/articles\/Data+Generation\/87901\/\r\n\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;newid()\u4fdd\u8bc1\u6bcf\u6b21\u90fd\u968f\u673a &#8211;checksum \u8f6c\u6210\u6570\u5b57\uff0c\u53ef\u80fd\u6709\u8d1f\u6570 &#8211;rand\u4fdd\u8bc1\u6570\u5b57\u90fd\u662f\u6b63\u6570,\u4e14 [&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-2250","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\/2250","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=2250"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2250\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}