CREATE procedure dbo.[Select]
@UserID varchar(15),
@DeleteFlag bit
asif @DeleteFlag=0
Begin
select * from TM02 where UserID=@UserID and DeleteFlag <>1
Endif @DeleteFlag=1
Begin
select * from TM02 where UserID=@UserID
EndGO
@UserID varchar(15),
@DeleteFlag bit
asif @DeleteFlag=0
Begin
select * from TM02 where UserID=@UserID and DeleteFlag <>1
Endif @DeleteFlag=1
Begin
select * from TM02 where UserID=@UserID
EndGO
@UserID varchar(15),
@DeleteFlag bit asif @DeleteFlag=0
Begin
select * from TM02 where UserID=@UserID and DeleteFlag <>1
Endif @DeleteFlag=1
Begin
select * from TM02 where UserID=@UserID
EndGO/*
1. select 是SQL的保留字,最好更换一个,如:proc_select
2. 第三行,@UserID varchar(15) 前的空格 换成英文空格*/