Question

在SQL Server2000中，每个程序块的开始标记为关键字 ，结束标记为关键字

Answer 1

TOP是SQL保留字你改成：[top]

<%
if city="" then
sql="select top 3 * from nyeee_data where mark='yes' and mark='yes' and stop >= getdate() and shouye=1 and pic <>'' order by [top] desc,money desc,adid desc"
else
sql="select top 3 * from nyeee_data where mark='yes' and city ='"&city&"' and mark='yes' and stop >= getdate() and shouye=1 and pic <>'' order by [top] desc,money desc,adid desc"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,connstr,1,1
if rs.eof then%>

Answer 2

begin
程序代码
end