Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASAÖÐÆæ¹ÖSQL£¿

4 posts in iAnywhere General Discussion (Chinese) Last posting was on 2004-09-16 14:04:23.0Z
back Posted on 2004-09-13 03:03:14.0Z
From: "back" <xuzhou@mc-cn.com>
Newsgroups: ianywhere.public.chinese.general
Subject: ASAÖÐÆæ¹ÖSQL£¿
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: 211.95.204.77
Message-ID: <41450fa3@forums-2-dub>
X-Original-Trace: 12 Sep 2004 20:10:27 -0700, 211.95.204.77
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Sep 2004 19:51:21 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Sep 2004 20:03:14 -0700
X-Trace: forums-1-dub 1095044594 10.22.108.75 (12 Sep 2004 20:03:14 -0700)
X-Original-Trace: 12 Sep 2004 20:03:14 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:314
Article PK: 459

¿´ÒÔÏÂÁ½¸öSQL£º

1.select * from tableX where A = '0'
2.select * from tableX where A = '0 '

×Ö¶ÎAÊÇvarcharÀàÐÍ£¬µÚ¶þ¸öSQLÖвÎÊý¶àÁËÒ»¸ö¿Õ¸ñ£»

ÎÒÔÚÁ½¸ö²»Í¬µÄASA7.0Êý¾Ý¿âÖÐÖ´ÐÐÒÔÉÏSQL£»
µÚÒ»¸öÊý¾Ý¿â£¬Á½¸öSQL·µ»Ø½á¹ûÒ»Ñù£»
µÚÒ»¸öÊý¾Ý¿â£¬Ö»ÓеÚÒ»¸öSQLÄÜ·µ»Ø½á¹û¡£

ÕâÁ½¸öSQL¾¿¾¹ÓкÎÇø±ð£¿


Raymond Kwong Posted on 2004-09-13 14:32:54.0Z
From: "Raymond Kwong" <rkwong@ianywhere.com>
Newsgroups: ianywhere.public.chinese.general
References: <41450fa3@forums-2-dub>
Subject: Re: ASAÖÐÆæ¹ÖSQL£¿
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rkwong-pc.sybase.com
X-Original-NNTP-Posting-Host: rkwong-pc.sybase.com
Message-ID: <4145af96$1@forums-1-dub>
Date: 13 Sep 2004 07:32:54 -0700
X-Trace: forums-1-dub 1095085974 10.25.101.243 (13 Sep 2004 07:32:54 -0700)
X-Original-Trace: 13 Sep 2004 07:32:54 -0700, rkwong-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:315
Article PK: 372

µ±´´½¨Êý¾Ý¿âʱ£¬Äú¿ÉÒÔָʾÊÇ·ñºöÂÔβËæ¿Õ°×»ò²»ºöÂÔβËæ¿Õ°×ÒÔ½øÐбȽϡ£

ȱʡÇé¿öÏ£¬´´½¨Êý¾Ý¿âʱ²»ºöÂÔβËæ¿Õ°×¡£ÀýÈ磬 "Dirk" ºÍ"Dirk " ²»Í¬¡£Äú¿ÉÒÔ
´´½¨¾ßÓпոñÌî³äµÄÊý¾Ý¿â£¬ÒÔ±ãºöÂÔβËæ¿Õ°×¡£



CREATE DATABASE BLANK PADDING×Ó¾ä

dbinit -b

"back" <xuzhou@mc-cn.com> wrote in message news:41450fa3@forums-2-dub...
> ¿´ÒÔÏÂÁ½¸öSQL£º
>
> 1.select * from tableX where A = '0'
> 2.select * from tableX where A = '0 '
>
> ×Ö¶ÎAÊÇvarcharÀàÐÍ£¬µÚ¶þ¸öSQLÖвÎÊý¶àÁËÒ»¸ö¿Õ¸ñ£»
>
> ÎÒÔÚÁ½¸ö²»Í¬µÄASA7.0Êý¾Ý¿âÖÐÖ´ÐÐÒÔÉÏSQL£»
> µÚÒ»¸öÊý¾Ý¿â£¬Á½¸öSQL·µ»Ø½á¹ûÒ»Ñù£»
> µÚÒ»¸öÊý¾Ý¿â£¬Ö»ÓеÚÒ»¸öSQLÄÜ·µ»Ø½á¹û¡£
>
> ÕâÁ½¸öSQL¾¿¾¹ÓкÎÇø±ð£¿
>
>


back Posted on 2004-09-15 01:27:59.0Z
From: "back" <xuzhou@mc-cn.com>
Newsgroups: ianywhere.public.chinese.general
References: <41450fa3@forums-2-dub> <4145af96$1@forums-1-dub>
Subject: Re: ASAÖÐÆæ¹ÖSQL£¿
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: 211.95.204.77
Message-ID: <41479c58$1@forums-2-dub>
X-Original-Trace: 14 Sep 2004 18:35:20 -0700, 211.95.204.77
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Sep 2004 18:15:55 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Sep 2004 18:27:59 -0700
X-Trace: forums-1-dub 1095211679 10.22.108.75 (14 Sep 2004 18:27:59 -0700)
X-Original-Trace: 14 Sep 2004 18:27:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:316
Article PK: 455

Èç¹ûÊý¾Ý¿âÒѾ­´´½¨£¬ÄÜ·ñ½«ÆäÉèÖøü¸ÄΪºöÂÔβËæ¿Õ°×£¿

"Raymond Kwong" <rkwong@ianywhere.com> дÈëÓʼþ
news:4145af96$1@forums-1-dub...

> µ±´´½¨Êý¾Ý¿âʱ£¬Äú¿ÉÒÔָʾÊÇ·ñºöÂÔβËæ¿Õ°×»ò²»ºöÂÔβËæ¿Õ°×ÒÔ½øÐбȽϡ£
>
> ȱʡÇé¿öÏ£¬´´½¨Êý¾Ý¿âʱ²»ºöÂÔβËæ¿Õ°×¡£ÀýÈ磬 "Dirk" ºÍ"Dirk " ²»Í¬¡£Äú¿É
ÒÔ
> ´´½¨¾ßÓпոñÌî³äµÄÊý¾Ý¿â£¬ÒÔ±ãºöÂÔβËæ¿Õ°×¡£
>
>
>
> CREATE DATABASE BLANK PADDING×Ó¾ä
>
> dbinit -b
>
>
>
>
>
>
>
> "back" <xuzhou@mc-cn.com> wrote in message news:41450fa3@forums-2-dub...
> > ¿´ÒÔÏÂÁ½¸öSQL£º
> >
> > 1.select * from tableX where A = '0'
> > 2.select * from tableX where A = '0 '
> >
> > ×Ö¶ÎAÊÇvarcharÀàÐÍ£¬µÚ¶þ¸öSQLÖвÎÊý¶àÁËÒ»¸ö¿Õ¸ñ£»
> >
> > ÎÒÔÚÁ½¸ö²»Í¬µÄASA7.0Êý¾Ý¿âÖÐÖ´ÐÐÒÔÉÏSQL£»
> > µÚÒ»¸öÊý¾Ý¿â£¬Á½¸öSQL·µ»Ø½á¹ûÒ»Ñù£»
> > µÚÒ»¸öÊý¾Ý¿â£¬Ö»ÓеÚÒ»¸öSQLÄÜ·µ»Ø½á¹û¡£
> >
> > ÕâÁ½¸öSQL¾¿¾¹ÓкÎÇø±ð£¿
> >
> >
>
>


Raymond Kwong Posted on 2004-09-16 14:04:23.0Z
From: "Raymond Kwong" <rkwong@ianywhere.com>
Newsgroups: ianywhere.public.chinese.general
References: <41450fa3@forums-2-dub> <4145af96$1@forums-1-dub> <41479c58$1@forums-2-dub>
Subject: Re: ASAÖÐÆæ¹ÖSQL£¿
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rkwong-pc.sybase.com
Message-ID: <41499f25$1@forums-2-dub>
X-Original-Trace: 16 Sep 2004 07:11:49 -0700, rkwong-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Sep 2004 06:52:10 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Sep 2004 07:04:23 -0700
X-Trace: forums-1-dub 1095343463 10.22.108.75 (16 Sep 2004 07:04:23 -0700)
X-Original-Trace: 16 Sep 2004 07:04:23 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.chinese.general:317
Article PK: 427

²»ÄÜÁË¡£

»°ËäÈç´Ë£¬Ä㻹ÊÇ¿ÉÒÔ¸ü¸ÄÄãµÄSQLÒÔ´ïÖÁºöÂÔβËæ¿Õ°×µÄЧ¹û¡£Àý×ÓÈçÏ£º

select * from tableX where RTRIM(A) = RTRIM('0 ')

"back" <xuzhou@mc-cn.com> wrote in message news:41479c58$1@forums-2-dub...
> Èç¹ûÊý¾Ý¿âÒѾ­´´½¨£¬ÄÜ·ñ½«ÆäÉèÖøü¸ÄΪºöÂÔβËæ¿Õ°×£¿
>
> "Raymond Kwong" <rkwong@ianywhere.com> дÈëÓʼþ
> news:4145af96$1@forums-1-dub...
> > µ±´´½¨Êý¾Ý¿âʱ£¬Äú¿ÉÒÔָʾÊÇ·ñºöÂÔβËæ¿Õ°×»ò²»ºöÂÔβËæ¿Õ°×ÒÔ½øÐбȽϡ£
> >
> > ȱʡÇé¿öÏ£¬´´½¨Êý¾Ý¿âʱ²»ºöÂÔβËæ¿Õ°×¡£ÀýÈ磬 "Dirk" ºÍ"Dirk " ²»Í¬¡£Äú
¿É
> ÒÔ
> > ´´½¨¾ßÓпոñÌî³äµÄÊý¾Ý¿â£¬ÒÔ±ãºöÂÔβËæ¿Õ°×¡£
> >
> >
> >
> > CREATE DATABASE BLANK PADDING×Ó¾ä
> >
> > dbinit -b
> >
> >
> >
> >
> >
> >
> >
> > "back" <xuzhou@mc-cn.com> wrote in message news:41450fa3@forums-2-dub...
> > > ¿´ÒÔÏÂÁ½¸öSQL£º
> > >
> > > 1.select * from tableX where A = '0'
> > > 2.select * from tableX where A = '0 '
> > >
> > > ×Ö¶ÎAÊÇvarcharÀàÐÍ£¬µÚ¶þ¸öSQLÖвÎÊý¶àÁËÒ»¸ö¿Õ¸ñ£»
> > >
> > > ÎÒÔÚÁ½¸ö²»Í¬µÄASA7.0Êý¾Ý¿âÖÐÖ´ÐÐÒÔÉÏSQL£»
> > > µÚÒ»¸öÊý¾Ý¿â£¬Á½¸öSQL·µ»Ø½á¹ûÒ»Ñù£»
> > > µÚÒ»¸öÊý¾Ý¿â£¬Ö»ÓеÚÒ»¸öSQLÄÜ·µ»Ø½á¹û¡£
> > >
> > > ÕâÁ½¸öSQL¾¿¾¹ÓкÎÇø±ð£¿
> > >
> > >
> >
> >
>
>