SqlService 数据操作

 存储过程：

 if exists(select * from sysobjects where name='proce_name')
 drop procedure proce_name
 go
 create procedure proce_name
 @id int,
 @name varchar(10),
 @outname varchar(20) out
 as    
    set @outname='历史';
go
declare @aa varchar(10);
    exec proce_name 1,'',@aa out;
    print @aa;