|
#2
mxbing19842015-04-17 17:16
|
程序代码：declare @hao varchar(50);
set @hao='01015000001';
declare @P varchar(50);
set @P='P';
select @hao
select * from PDM_DOCID where CSYMBOL in (@P+@hao)
/*select @hao=convert(int,@hao)
select @hao*/
declare @has varchar(50)
select @has=convert(varchar,@hao)
select @has
select * from PDM_DOCID where CSYMBOL in (@P+@has);
我注销的那段加上的话，两个查询结果就不一样了，如果不加的话，两个查询语句的结果就是一样的。我觉得应该是int无法转回varchar，求怎么转。cast和convert我都用过了。没一个成功的。求解决办法 set @hao='01015000001';
declare @P varchar(50);
set @P='P';
select @hao
select * from PDM_DOCID where CSYMBOL in (@P+@hao)
/*select @hao=convert(int,@hao)
select @hao*/
declare @has varchar(50)
select @has=convert(varchar,@hao)
select @has
select * from PDM_DOCID where CSYMBOL in (@P+@has);