＋设为首页 ＋添加到收藏夹
我做了一个如下的存储过程，
create proc usp_AAInvoiceManagement_Search
@InvoiceNo nvarchar (20),
@PayDate smalldatetime,
@FactoryName nvarchar(60)
as
select * from AAInvoiceManagement
where InvoiceNo=@InvoiceNo and
PayDate=@PayDate and
FactoryName=@FactoryName
order by invoiceno
go
其中nvarchar字段为中文，我执行如下，
exec usp_AAInvoiceManagement_Search 0508001,2002-5-5,深圳市华茂实业发展有限公司
go
但就是查不到任何记录，但是如果我把nvarchar字段去掉的话，就可以，我想请问一下要怎样来处理那个中文字段呢？谢谢！
datetime 出问题:
PayDate=@PayDate and
==>convert(varchar(10),PayDate,120)=convert(varchar(10),@PayDate 120) and
create proc usp_AAInvoiceManagement_Search
@InvoiceNo nvarchar (20),
@PayDate smalldatetime,
@FactoryName nvarchar(60)
as
select * from AAInvoiceManagement
where rtrim(InvoiceNo)=@InvoiceNo and
PayDate=@PayDate and
FactoryName=@FactoryName
order by invoiceno
go
exec usp_AAInvoiceManagement_Search N0508001,2002-5-5,N深圳市华茂实业发展有限公司
