我写了段代码如下
CREATE PROCEDURE ado_outplate_dele
@outinvoice char(10), @factorycode char(10), @batchno char(10),@model char(20),@modelexp varchar(20), @platesort char(40), @platecolor varchar(50),
@incomingquality int ASupdate outplate set incomingquality =( incomingquality - @incomingquality)
where (invoice=@outinvoice) and (factorycode =@factorycode) and (batchno=@batchno) and (model=@model) and (backinvoice=@modelexp)
and (platesort=@platesort) and (platecolor=@platecolor)
select * from outplate
where (invoice=@outinvoice) and (factorycode =@factorycode) and (batchno=@batchno) and (model=@model) and (backinvoice=@modelexp)为什么当我给@model的值里面有汉字的时候就不能查找到那条记录,比如'LGK中国'那样就找不着记录,如时是'LSDFS'全部是英文或数字就行的呢?为什么啊,真是急死我了
CREATE PROCEDURE ado_outplate_dele
@outinvoice char(10), @factorycode char(10), @batchno char(10),@model char(20),@modelexp varchar(20), @platesort char(40), @platecolor varchar(50),
@incomingquality int ASupdate outplate set incomingquality =( incomingquality - @incomingquality)
where (invoice=@outinvoice) and (factorycode =@factorycode) and (batchno=@batchno) and (model=@model) and (backinvoice=@modelexp)
and (platesort=@platesort) and (platecolor=@platecolor)
select * from outplate
where (invoice=@outinvoice) and (factorycode =@factorycode) and (batchno=@batchno) and (model=@model) and (backinvoice=@modelexp)为什么当我给@model的值里面有汉字的时候就不能查找到那条记录,比如'LGK中国'那样就找不着记录,如时是'LSDFS'全部是英文或数字就行的呢?为什么啊,真是急死我了
解决方案 »
- Delphi 道馆2群:25911444(可容纳500人)欢迎各路DELPHI人士加入~~~~~
- 关于操作文件和文件夹的例子
- 接口的理解问题?
- 急!!!帮帮忙,请问如何实现显示所有正在执行的应用程序
- SQL Server中存储doc文件的问题
- 自动设置QRDBText的LEFT属性?
- 谁有reportmachine的rm3.rar文件的解压缩密码,烦请告之,感激不尽,谢谢!
- dll文件操作
- 在DELPHI中调用ORACLE存储过程中的CURSOR输出参数,oracle部分已解决,delphi这边用ADO怎样实现?
- Access和SQL Server
- 如何做一个类似kele8那样的情景聊天室?各位高手,看看呀,给点意见
- 数据合并问题?
顺便linzhisong(無聊)的建议也应该考虑