全部经过测试:select * from b where姓名 like '%勇%' and year(出生日期) like '%78%'select count(编号) as 人数 from bselect * from B where 出生日期=(select min(出生日期) from B) create table c(编号 int identity (1,1) primary key not null,姓名 char(8),出生时间 datetime)insert into c select 姓名,出生日期 from b或者select top 0 * into C from B create PROCEDURE getRow1 as select * from B where 编号=1 delete from a where C_ID not in(select C_ID from D)to mxm1123:你太快了!