我有一个表plan_scheme该表具有列头代码 [英] I have one table plan_scheme that table having column headcode
本文介绍了我有一个表plan_scheme该表具有列头代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个table plan_scheme表,列表头码是单个数字我想在该列中添加零,如果单个数字表示
2,它就像02, 05,08同样是32,34,因为它是两位数。
如何写查询。
解决方案
更新 plan_scheme SET headcode =
( CASE WHEN LEN(headcode)= 1 那么 RIGHT (' 0' + CONVERT ( VARCHAR ,headcode), 2 )
ELSE headcode END );
选择 * 来自 plan_scheme
试试这个.. :)
选择 < span class =code-keyword> case len(headcode) 1 然后 ' 0' + convert( varchar ,headcode) else convert ( varchar ,headcode) end as value 来自 headcode
CREATE TABLE plan_scheme
(
headcode varchar ( 5 )
)
insert into plan_scheme values (' 01 ')
SELECT * 来自 plan_scheme
添加预
标签。
< I> [/编辑] 的
I have one table plan_scheme that table having column headcode single digit i want to add zero in that column if single digit means
2, it's like a 02,05,08 likewise 32, 34, two digit as it is
how to write query .
解决方案
UPDATE plan_scheme SET headcode = (CASE WHEN LEN(headcode ) = 1 THEN RIGHT('0' + CONVERT(VARCHAR, headcode ), 2) ELSE headcode END); select * from plan_scheme
try this.. :)
select case len(headcode) when 1 then '0'+convert(varchar,headcode) else convert(varchar,headcode) end as value from headcode
CREATE TABLE plan_scheme ( headcode varchar(5) ) insert into plan_scheme values('01') SELECT * from plan_scheme
[Edit member="Tadit"]
Addedpre
tags.
[/Edit]
这篇关于我有一个表plan_scheme该表具有列头代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文