默认值

?TextBox: 默认为空字串””, 而不是null

SELECT? @OrderNo = OrderNo FROM bdOrder a
JOIN bmdCustomer b ON a.customerid = b.id WHERE b.Tel = ‘13769688430’

@OrderNo 的值为查询到的值, 若一条数据也没有,则@OrderNo保留原值