存储过程,多条件删除

[tjbus2008]

Create Proc Proc_DeleteBaseData1(
@txtone varchar(50),
@txttwo varchar(50),
@txtcontion varchar(50),
@outprint varchar(50) output)
as
begin
if @txtcontion='全部'
delete from 基础数据 where 日期 between @txtone and @txttwo
else
delete from 基础数据 where 车队 in (@txtcontion) and 日期 between @txtone and @txttwo
END
SET @outprint='删除成功'
影响行数为0
其中@txtcontion有可能是选择的多个车队,1车队,2车队,3车队,或者只是一个车队,例如1车队.
不知道如何解决,谢谢

[-狙击手-]

Create Proc Proc_DeleteBaseData1( 
@txtone varchar(50), 
@txttwo varchar(50), 
@txtcontion varchar(50), 
@outprint varchar(50) output) 
as 
begin 
if @txtcontion='全部' 
delete from 基础数据 where 日期 between @txtone and @txttwo 
else 
delete from 基础数据 where charindex(','+车队+',',','+@txtcontion+',')>0 and 日期 between @txtone and @txttwo 
END 
SET @outprint='删除成功' 

[-狙击手-]

Create Proc Proc_DeleteBaseData1( 
@txtone varchar(50), 
@txttwo varchar(50), 
@txtcontion varchar(50), 
@outprint varchar(50) output) 
as 
begin 
if @txtcontion='全部' 
delete from 基础数据 where 日期 between @txtone and @txttwo 
else 
delete from 基础数据 where charindex(','+车队+',',','+@txtcontion+',')>0 and 日期 between @txtone and @txttwo 
END 
SET @outprint='删除成功' 

[SQL77]

[Quote=引用 1 楼 happyflystone 的回复:]
SQL codeCreate Proc Proc_DeleteBaseData1(
@txtone varchar(50),
@txttwo varchar(50),
@txtcontion varchar(50),
@outprint varchar(50) output)
as
begin
if @txtcontion='全部'
delete from 基础数据 where 日期 between @txtone and @txttwo
else
delete from 基础数据 where charindex(','+车队+',',','+@txtcontion+',')>0 and 日期 between @txtone and @txttwo
END
SET @outprint='删除成功'
[/Quote]

速度啊!!!真快!!!

[无心雨云]

学了

[tjbus2008]

exec proc_deletebasedata1 '878车队','2009-04-01','2009-04-01','删除成功'
返回的是影响行数0

[-狙击手-]

你select 一下看看有没有结果，说不定本身就没有记录满足
看看是不是有空格
--try

Create Proc Proc_DeleteBaseData1( 
@txtone varchar(50), 
@txttwo varchar(50), 
@txtcontion varchar(50), 
@outprint varchar(50) output) 
as 
begin 
if @txtcontion='全部' 
delete from 基础数据 where 日期 between @txtone and @txttwo 
else 
delete from 基础数据 where charindex(','+ltrim(rtrim(车队))+',',','+@txtcontion+',')>0 and 日期 between @txtone and @txttwo 
END 
SET @outprint='删除成功'