{"id":174,"date":"2006-12-29T02:31:41","date_gmt":"2006-12-29T02:31:41","guid":{"rendered":"http:\/\/www.jason695.idv.tw:81\/wordpress\/?p=174"},"modified":"2006-12-29T02:31:41","modified_gmt":"2006-12-29T02:31:41","slug":"rand-transact-sql","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2006\/12\/29\/rand-transact-sql\/","title":{"rendered":"RAND (Transact-SQL)"},"content":{"rendered":"<p><strong>\u5728SQL SERVER\u53d6\u4e82\u6578\u7684\u65b9\u5f0f\uff1a<br \/>\n<\/strong><br \/>\nms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.zh-CHT\/tsqlref9\/html\/363c84d6-b9fa-49ba-9a75-e44f27535ff6.htm<\/p>\n<p><strong>\u7bc4\u4f8b\uff1a\u00a0<\/strong><\/p>\n<pre>DECLARE @counter smallint\r\nSET @counter = 1\r\nWHILE @counter < 5\r\nBEGIN\r\nSELECT RAND() Random_Number\r\nSET @counter = @counter + 1\r\nEND\r\nGO<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5728SQL SERVER\u53d6\u4e82\u6578\u7684\u65b9\u5f0f\uff1a ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.z &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2006\/12\/29\/rand-transact-sql\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">RAND (Transact-SQL)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-174","post","type-post","status-publish","format-standard","hentry","category-5","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}