select A.*,B.* into #temp from A,B

declare @sql varchar(1000)
set @sql='select ID,Discription  from #temp where 
'+第一个字段+' like ''%'+第一个条件值+'%'''   or 其它的条件

exec (@sql)
delete table #temp

------解决方案--------------------
SQL code

Select a.ID,b.Discription From tableA a Left Outer Join tableB b On a.ID=b.ID 
Where ID='%输入的数据%' or Name='%输入的数据%' or BirthYear='%输入的数据%' or BirthMonth='%输入的数据%' or BirthDay='' 
Or Sex='输入的数据'

------解决方案--------------------
SQL code

Select a.ID,b.Discription From tableA a Left Outer Join tableB b On a.ID=b.ID 
Where ID like '%输入的数据%' or Name like '%输入的数据%' 
or convert(varchar(4),year(Birthday)) like '%输入的年%' 
or convert(varchar(4),month(Birthday)) like '%输入的月%' 
or convert(varchar(4),day(Birthday)) like '%输入的日%' 
Or Sex='输入的数据'