modify stored procedure name in sql server code example

Example: rename stored procedure in sql server

--Rename the stored procedure.  
EXEC sp_rename 'OldName', 'NewName';