创建存储过程出错。不知道哪里出了问题呢~~
在查询分析器里面的代码是：
create procedure proc_customerbuytotal
@datefrom datetime,
@dateto datetime
as
select sales.customercode, customer.customername,customer.company,customer.tel,customer.address,customer.postcode,
sum(salesdetail.saleqty*salesdetail.actprice)'amount'
from sales,salesdetail,customer
where(sales.customercode <>"and sales.customercode is not null)
and customer.customercode=sales.customercode
and sales.billno=salesdetail.billno
and (sales.saledate>= @datefrom and sales.saledate<=@dateto)
group by sales.customercode,customer.customername,customer.company,customer.tel,customer.address,customer.postcode
order by sales.customercode
go
[解决办法]
where(sales.customercode <>"and sales.customercode is not null)
---------
你那是个双引号，应该是2个单引号
