{"id":180,"date":"2011-12-30T06:39:48","date_gmt":"2011-12-30T06:39:48","guid":{"rendered":"http:\/\/ahsiu.com\/?p=180"},"modified":"2011-12-30T06:39:48","modified_gmt":"2011-12-30T06:39:48","slug":"sql-server-%e4%b8%ad%e5%8f%96%e5%8d%81%e4%bd%8d%e9%9a%8f%e6%9c%ba%e5%ad%97%e7%ac%a6%e4%b8%b2","status":"publish","type":"post","link":"https:\/\/blog.xiunian.wang\/?p=180","title":{"rendered":"sql server \u4e2d\u53d6\u5341\u4f4d\u968f\u673a\u5b57\u7b26\u4e32"},"content":{"rendered":"
———————-\u5b57\u7b26\u4e32\u4e2d\u6709\u91cd\u590d\u7684\u5b57\u7b26——————–
\ndeclare @l int
\ndeclare @s varchar(26)
\ndeclare @r varchar(200)
\nset @l = 10 ———–\u8bbe\u7f6e\u8fd4\u56de\u957f\u5ea6\uff0c\u6700\u5927\u957f\u5ea6\u53d7@r\u7684\u9650\u5236
\nset @s = ‘abcdefghijklmnopqrstuvwxyz’
\nset @r = ”
\nwhile len(@r) < @l
\nbegin
\nset @r = @r + substring(@s, cast(rand() * 100 as int) % 26 +1 , 1)
\nend
\nprint @r<\/p>\n

——————–\u5b57\u7b26\u4e32\u4e2d\u65e0\u91cd\u590d\u5b57\u7b26———————————-<\/p>\n

declare @s varchar(26)
\ndeclare @r varchar(8)
\ndeclare @t varchar(1)
\nset @s = ‘abcdefghijklmnopqrstuvwxyz’
\nset @r = ”<\/p>\n

while len(@r) < 8
\nbegin
\nset @t = substring(@s, cast(rand() * 100 as int) % 26 +1 , 1)
\nif charindex(@t, @r) < 1
\nset @r = @r + @t
\nend
\nprint @r<\/p>\n

——————–\u5b57\u7b26\u4e32\u4e2d\u65e0\u91cd\u590d\u5b57\u7b26\u51fd\u6570———————————-
\nALTER FUNCTION dbo.GetRandStr
\n(@Count INTEGER = 8)
\nRETURNS VARCHAR
\nAS
\nBEGIN
\nDECLARE @STR VARCHAR(100), @STR1 VARCHAR(36)
\nDECLARE @I INTEGER, @J INTEGER, @M INTEGER, @N INTEGER
\nSET @STR1 = ‘0123456789abcdefghijklmnopqrstuvwxyz’
\nSET @I = 1
\nSET @M = 1
\nSET @STR = ”
\nWHILE @I <= 36
\nBEGIN
\nHERE:
\nSET @M = CAST(dbo.RAND() * 100 \/ 2.75 AS INTEGER)
\nIF (@M < 1) OR (@M = @N) OR (CHARINDEX(SUBSTRING(@STR1, @M ,1), @STR)) > 0 GOTO HERE
\nSET @N = @M
\nSET @STR = @STR + SUBSTRING(@STR1, @M ,1)
\nSET @I = @I + 1
\nEND
\nRETURN @STR
\nEND<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

———————-\u5b57\u7b26\u4e32\u4e2d\u6709\u91cd\u590d\u7684\u5b57\u7b26——————– declare @l int declare @s varchar(26) declare @r varchar(200) set @l = 10 ———–\u8bbe\u7f6e\u8fd4\u56de\u957f\u5ea6\uff0c\u6700\u5927\u957f\u5ea6\u53d7@r\u7684\u9650\u5236 set @s = ‘abcdefghijklmnopqrstuvwxyz’ set @r = ” while len(@r) < @l begin set @r = @r + substring(@s, cast(rand() * 100 as int) % 26 +1 , 1) end print @r ——————–\u5b57\u7b26\u4e32\u4e2d\u65e0\u91cd\u590d\u5b57\u7b26———————————- declare @s varchar(26) declare @r varchar(8) declare … <\/p>\n

Continue reading “sql server \u4e2d\u53d6\u5341\u4f4d\u968f\u673a\u5b57\u7b26\u4e32”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts\/180"}],"collection":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=180"}],"version-history":[{"count":0,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts\/180\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}