如何进行查询以更改数据 [英] How to make query to change data

问题描述

我需要帮助，

i有数据栏

[DE01]

[DE02]

[DE03] ]

[DE04]



i wana改为

[DE001]

[DE002]

[DE003]

[DE004]





如何使用查询存储过程进行更改？

I need help,
i have data column
[DE01]
[DE02]
[DE03]
[DE04]

i wana to change to be
[DE001]
[DE002]
[DE003]
[DE004]


how to change with query stored procedure?

推荐答案

查看此

check this

select Stuff('[DE01]',4,0,'0')

而不是'[DE01]'您可以给出数据列的名称。

instead of '[DE01]' you can give the name of your data column.

阅读以下内容： http://stackoverflow.com/questions/9520661/fo rmatting-numbers-by-padding-with-leading-zeros-in-sql-server [ ^ ]

Read the following : http://stackoverflow.com/questions/9520661/formatting-numbers-by-padding-with-leading-zeros-in-sql-server[^]

只是简单，

just simple,

Update tbItemList
set Tag =  SUBSTRING(Tag,1,2) + '0' + SUBSTRING(Tag,3,2)
WHERE DatabaseID='250'

这个有效....

this works....

这篇关于如何进行查询以更改数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！