抱歉,收回刚才的回复.
create table #t(i int,a varchar(10))
insert into #t values(10,'45')
insert into #t values(100,'test45')
select count(10) from #t
select (0) from #t
drop table #t
=========结果:=====================
2
-----------
0
0
-----------
从结果可以看出来,我的想法是错的...
create table #t(i int,a varchar(10))
insert into #t values(10,'45')
insert into #t values(100,'test45')
select count(10) from #t
select (0) from #t
drop table #t
=========结果:=====================
2
-----------
0
0
-----------
从结果可以看出来,我的想法是错的...
如select log from table 总是提示log要加引号,加引号后,查询出来的结果并不是想要的。不知问题怎么解决?谢谢!!!!
select [log] from table
select 1 from tale1
1
1
1
...