这个查询语名怎样写?

[jqlin]

以下两个写法，第一条不会出错，第二条会出错，但我想实现第二条的功能，即有多个条件，把where后面的内容都用变量的形式表式出来，这个语句怎样写?

1.tj="男"
sqltemp1="select * from user where 姓别='"&tj&"'"

2.
tj="姓别=男 and 出生年月>"2000-01-01""
sqltemp1="select * from user where '"&tj&"'"

[Reker熊]

tj="姓别='男' and 出生年月>#2000-01-01#"
sqltemp1="select * from user where "&tj

[srz007]

tj1="男"
tj2="2000-01-01"
sqltemp1="select * from user where 姓别='"&tj1&"'" &"and 出生年月>'"&tj2&"'"

[jobine]

tj=" 姓别='男' and 出生年月>'2000-01-01'"
sqltemp1="select * from user where "&tj

[jqlin]

还不会出错!

[cpp2017]

什么数据库?
sqlserver:

tj =" and 姓别=N'男' and DateDiff(d,出生年月,'2000-01-01')<0 "
sqltemp1 ="select * from user where 1=1 " & tj

Access:
tj =" and 姓别=N'男' and DateDiff(d,出生年月,#2000-01-01#)<0 "
sqltemp1 ="select * from user where 1=1 " & tj

[cpp2017]

什么数据库?
sqlserver:

tj =" and 姓别=N'男' and DateDiff(d,出生年月,'2000-01-01')<0 "
sqltemp1 ="select * from user where 1=1 " & tj

Access:
tj =" and 姓别='男' and DateDiff(d,出生年月,#2000-01-01#)<0 "
sqltemp1 ="select * from user where 1=1 " & tj

[lyhang801]

tj="姓别='男' and 出生年月>'2000-01-01'"
sqltemp1="select * from user where '"&tj&"'"