my-sql 创建存储过程

use test                                        

create procedure show_a()          

select * from a                               

                                                     

                                                     

call show_a();                                

                                                     

                                                     

                                                     

                                                     

 

 

简单创建和执行

 

上面是mysql 的而sql server 就不一样了，

create procedure show_a

as

select * from a