case语句问题 ( 积分: 50 )

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #1

在sql语句中写
case pr.typeid when 1 then 'aaaaaaaaaaaaabbbbbbbbbbccccccccccccdddddd'end
as type
但在DBGrid中却只显示'aaaaaaaaaaaaabbbbbbbbbbccccccccccccdddddd'前10字符，怎么设置虚拟字段type的长度

 

L

levi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #2

case pr.typeid when 1 then Cast( 'aaaaaaaaaaaaabbbbbbbbbbccccccccccccdddddd' as varchar(1000)) end
as type

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-15

• #3

不行

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-19

• #4

我查资料说
SQL语句中别名长度能显示30个字符。我这个怎么就能显示10个字符

 

W

willing66

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-20

• #5

CONVERT( VARCHAR(100), case pr.typeid when 1 then 'aaaaaaaaaaaaabbbbbbbbbbccccccccccccdddddd'end)

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-20

• #6

不行，主要是type的长度

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-20

• #7

确定是30字符，是我写错了
抱歉