存储过程的定义：
create procedure procedurename
@param1 nvarchar(30)
as
select * from tablename where name = @param1
go
存储过程调用
exec procedurename N'test1'
exec procedurename @param1=N'test1';
GO
