ACCESS转为SQLSERVER后的问题~~

第一次用SQLSERVER
原来在ACCESS中的SQL语句是:
StrSql="Select * from Memolist Where PlanUser='"&Session("EmpName")&"' and PlanTime<#"&Now()&"# and PlanSign=1"

转为SqlServer后的语句是什么样的啊!@!
---------------------------------------------------------------

StrSql="Select * from Memolist Where PlanUser='"&Session("EmpName")&"' and PlanTime<'"&Now()&"' and PlanSign=1"
---------------------------------------------------------------

access中日期用##标志
sqlserver用'
---------------------------------------------------------------

StrSql="Select * from Memolist Where PlanUser='"&Session("EmpName")&"' and PlanTime<'" & Now() & "' and PlanSign=1"