sql 急问 大家看看这个语句错在哪里

[popcom]

sql:='select name from sysobjects where type=U';

[jinjazz]

sql:='select name from sysobjects where type=''U''';

[popcom]

为什么要加两个''u''啊

[kfb007]

sysobjects是什么数据库的什么表？

[劣势]

TYPE 字段是Char（2）类型的，所以要加'''',delphi中的''''表示一个‘’

[劣势]

SQLServer的系统表

[hxshaou]

sql:='select name from sysobjects where type=''U''';这样就对了

[cdwei80]

我用过

[lizhi012]

sql:='select name from sysobjects where type='+'''U'''';这样也可以。

[Merrybip]

sql:='select name from sysobjects where type=''U''';

[haorjiang]

sql:='select name from sysobjects where type=''U''';

[fdzxlg]

sql:='select name from sysobjects where type=:P0';
sql.add(sql);
paramters[0].value:='U';
open;

[socoolin1982]

sql:='select name form sysobjects where type ='''+'U'+'''';

[herman~~]

我喜欢这样
sql:='select name from sysobjects where type='+#39+'U'+#39;
这样也可以。

[microchu]

我喜欢这样
sql:='select name from sysobjects where type="'+'U'+'"';