create
proc test
@ref
varchar
(20),
@ret
varchar
(2)
output
as
if exists(
select
1
from
A
where
charindex(@ref,水果名称)>0)
set
@ret=
'有'
else
set
@ret=
'无'
return
@ret
GO
转载于:https://blog.51cto.com/4769069/1174775