This system stored procedure will help you to view the code of stored procedure from database which you have created without using any wizard .
suppose your stored procedure name is GetEmp,then you can use default sql stored procedure to view the code as