CREATE PROCEDURE du9fhjl1_dz
@xph char(7)
as
select *
from du9fhjl_dz
where xiaoph like '%'+@xph+'%'
GO查询分析器中execute du9fhjl1_dz '41'
@xph char(7)
as
select *
from du9fhjl_dz
where xiaoph like '%'+@xph+'%'
GO查询分析器中execute du9fhjl1_dz '41'
调试欢乐多
与where xiaoph=@xph等价
@xph char(7)
as
select *
from du9fhjl_dz
where xiaoph like '%'+@xph+'%'
GO
@xph char(7)
as
select *
from du9fhjl_dz
where xiaoph like '%'+@xph+'%'
GO