在存储过程中,如何得到字符串的第N位的值?

[daqi2010]

表oper
oper_id oper_rule
1 001100
2 111110
现在想得到@str_sum位是否为1,如果是,则取出oper_id


CREATE proc ---
@str_sum int
AS
---怎么写

[dawugui]

if substring(oper_rule , @str_sum , 1) = '1'
...

[claro]

帮顶．

[ks_reny]

@str_sum 是如何得來的?

[dawugui]

CREATE  procedure my_proc 
@str_sum int 
AS 
begin
  select * from oper where substring(oper_rule , @str_sum , 1) = '1' 
end
go

[cyz9977]

CREATE  proc  temp
@str_sum int 
AS 
begin
     select oper_id from oper where substring(oper_rule,@str_sum,1)=1
end

[yygyogfny]

create proc pr_test
@str_sum int
as
begin
select orer_id from oper where substring(oper_rule,@str_sum,1) = 1
end

[yygyogfny]

高手就是高手,,那速度~~哎

[ChinaJiaBing]

if object_id('oper')is not null
   drop table oper
if object_id('pro_c') is not null
   drop procedure pro_c
create table oper (oper_id int,oper_rule int)
insert into oper select 1,'001100'
     union all   select 2,'111110'
go
create procedure pro_c (@str_sum int)
as
set nocount on
select * from oper where oper_id=@str_sum
set nocount off
go
exec pro_c 1



oper_id     oper_rule
----------- -----------
1           1100

[ChinaJiaBing]

if object_id('oper')is not null
   drop table oper
if object_id('pro_c') is not null
   drop procedure pro_c
create table oper (oper_id int,oper_rule int)
insert into oper select 1,'001100'
     union all   select 2,'111110'
go
create procedure pro_c (@str_sum int)
as
set nocount on
select * from oper where SUBSTRING( cast(oper_id as varchar(10)),@str_sum,1)=1
set nocount off
go
exec pro_c 1


oper_id     oper_rule
----------- -----------
1           1100

[Zoezs]

[Quote=引用楼主 daqi2010 的帖子:]
表oper
oper_id oper_rule
1 001100
2 111110
现在想得到@str_sum位是否为1,如果是,则取出oper_id


CREATE proc ---
@str_sum int
AS
---怎么写
[/Quote]

你最好把@str_sum定义为字符型
否则需要用到convert
select @str_sum=convert(int,substring(oper_rule,0,1)) from oper where 
if @str_sum=1
Begin
.....

[zhouyongli41]

佩服一下