USE master
GO
drop proc myproc
go
//写存储过程
CREATE PROCEDURE myproc
@name VARCHAR(20)
AS
SELECT * FROM sysobjects WHERE xtype LIKE '%'+ @name +'%'
//调用
DECLARE @name VARCHAR(20)
SET @name = 's'
EXEC myproc @name
USE master
GO
drop proc myproc
go
//写存储过程
CREATE PROCEDURE myproc
@name VARCHAR(20)
AS
SELECT * FROM sysobjects WHERE xtype LIKE '%'+ @name +'%'
//调用
DECLARE @name VARCHAR(20)
SET @name = 's'
EXEC myproc @name
转载于:https://www.cnblogs.com/haoliansheng/archive/2009/07/23/1529534.html