怎样把下面的SQL语句写在一个存储过程中？（在线等待………急！！！）

Question

SELECT *
 FROM OPENQUERY(TWOA_Doc_Admin,
                 'SELECT Directory, 
                    FileName,
                    DocAuthor,
                    Size,
                    Create,
                    Write
                  FROM SCOPE()
  WHERE CONTAINS(''办公系统'')>0')
也就是怎们把字符'办公系统'用一个变量代替？本身这个查询在查询分析器里是可以执行的。
现在我要用它建一个存储过程，怎么写啊？

Answer 1

CREATE PROC [ EDURE ] procedure_name 
@mType varchar(20)
As
SELECT *
 FROM OPENQUERY(TWOA_Doc_Admin,
                 'SELECT Directory, 
                    FileName,
                    DocAuthor,
                    Size,
                    Create,
                    Write
                  FROM SCOPE()
  WHERE CONTAINS(''+@mType+'')>0')
Go

Answer 2

CREATE PROC  procedure_name 
@mType varchar(20)
As
SELECT *
 FROM OPENQUERY(TWOA_Doc_Admin,
                 'SELECT Directory, 
                    FileName,
                    DocAuthor,
                    Size,
                    Create,
                    Write
                  FROM SCOPE()
  WHERE CONTAINS(''+@mType+'')>0')
Go