(1)表: NX12420
info_date info_package info_used
2011/2/21 14:26:00 NX12420 10
2011/2/21 14:27:00 NX12420 7 查询结果:
NX12420=7(2)如何查询数据库中表名中包含"NX"和"in"的表名?
查询结果: NX12420_in
NX12410_in
info_date info_package info_used
2011/2/21 14:26:00 NX12420 10
2011/2/21 14:27:00 NX12420 7 查询结果:
NX12420=7(2)如何查询数据库中表名中包含"NX"和"in"的表名?
查询结果: NX12420_in
NX12410_in
from NX12420
order by info_date descselect * from sys.objects where name like '%NX%' and name like '%in%'
/* 1 */
select top 1 *
from tb
order by info_date desc--orselect *
from tb t
where not exists(select 1 from tb where info_date < t.info_date)/* 2 */select [name] from sysobjects where [name] like '%NX%in%' and xtype = 'U'
[/code]
select name from sysobjects where xtype='u' and name like 'NX' or name like 'in'
select name from sysobjects where xtype='u' and name like 'NX' and name like 'in'
declare @NX12420 table
(info_date datetime,info_package varchar(7),info_used int)
insert into @NX12420
select '2011/2/21 14:26:00','NX12420',10 union all
select '2011/2/21 14:27:00','NX12420',7select top 1 info_package+'='+cast(info_used as varchar(10)) as col
from @NX12420 order by info_date desc
/*
col
------------------
NX12420=7
*/
select * from sys.objects
where charindex('NX',[name])>0 and charindex('in',[name])>0
/*
name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date is_ms_shipped is_published is_schema_published
----------
NX12420in
*/
where charindex('NX',[name])>0 and charindex('in',[name])>0
select top 1 info_used
from NX12420
order by info_date desc2:
select * from sys.objects where name like '%NX%in%'
from NX12420
order by info_date desc select * from sys.objects where name like '%NX%' and name like '%in%'
and type = 'U'