sql server 2012怀疑 [英] sql server 2012 doubt

问题描述

大家好

我有这样的数据集

Hi all
I have the data set like this

studentidsystem	studentid	studentname
null	1	ramesh
null	2	raju
null	3	mahesh
null	4	balu
null	5	lakshman
null	6	aradhana
null	7	krithi
null	8	sudhakar

用于studentidsystem的
我想将值更新为

for studentidsystem I want to update values as

IN
IR
IE
IL
JM
JE
KZ

我想随机更新，但我必须使用studentidsystem的所有值



你可以帮我知道如何做到这一点。



问候

prakash.ch

I want update randomly but I have to use all the values of studentidsystem

could you helpme out how to do that.

Regards
prakash.ch

推荐答案

您可以在我的提示中找到：随机提取甲板上的5张卡片 [ ^ ]和e这样做的效率很高。

You may find in my tip: Random extraction of 5 cards from a deck[^] an efficient algorithm for doing that.

试试这个....

Try this....

DECLARE @ID varchar(2)
set @ID=''

select @ID=@ID+char(n) from
(select top 25 number as n from master..spt_values 
Where type='p' and number between 65 and 90
Order by newid()
) as t

select @ID as ID

< a href => http：/ /www.mssqltips.com/sqlservertip/2534/sql-server-stored-procedure-to-generate-random-passwords/

这篇关于sql server 2012怀疑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！