sqlserver中产生随机字符,随机数

SELECT REPLACE(NEWID(),'-','')

select replicate(char(cast(rand()*1000 as int)%26+97)
+char(cast(rand()*1000 as int)%26+97)
+char(cast(rand()*1000 as int)%26+97)
+char(cast(rand()*1000 as int)%26+97)
+char(cast(rand()*1000 as int)%26+97),(cast(rand()*100 as int)%6)+1)

http://q.cnblogs.com/q/45469/

http://blog.163.com/zangyunling@126/blog/static/1646245052010717115023216/