請教一個sql語句?(10分)

J

jesse.zhou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #1

在SQL Server中我有一個表(no int,name varchar(10))
4 XXXXX
5 AAAAA
6 BBBBB
11 CCCCC
我想要sql顯示
000004 XXXXX
000005 AAAAA
000006 BBBBB
000011 CCCCC
請教我?

 

N

newyu_1127

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #2

[^]试试这样行不行？
select right(cast(no+1000000 as varchar),6),name from tablename

 

对

对酒当歌

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #3

select right(cast((1000000+no) as char),6),name from mytable

 

M

muhaifeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #4

你干嘛要把编号字段设计为整形的呀，难道需要编号的累加值 ?

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #5

同意对酒当歌