通过自动生成字符串更新列 [英] update column by auto genrate string

问题描述

您好，我在更新sql server 2005中的列时遇到问题，我想更新一个列，其中每个输入的列密码都具有相同的密码.我想更新此列以生成自动生成的字符串，每个字符串都有不同的密码，任何人都可以建议我该怎么做.将是什么过程，任何人都可以向我发送有关查询的信息.
在此先感谢

Hello, I have a problem in update a column in sql server 2005, I want update a column in which column password have same password for every entry. i want update this column for auto genrate string, by which every one have different password, can any one suggest me how can i do it.what will be procedure , can any one tel me about the query.
Thanks in advance

推荐答案

您可以在SQL Server 2005中使用Identity列
像这样

表声明中的colname identity(1,1)

you can use identity column in sql server 2005
like this

colname identity(1,1) in your table declaration

create table nameoftable
(AutogeneratedIdColName int identity(1,1) , restof columns of your table)

您可以使用它，

hi you can use this,

update tablename set passwordcolumn=passwordcolumn+ cast(uridentycolumn as varchar(10))

where passwordcolumn   in
( select passwordcolumn from tablename
group by passwordcolumn
having count(*) > 1 )

这篇关于通过自动生成字符串更新列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！