Second question: is it possible to create stored procedure by MVC (no by SQL Server).
This is not really clear. Do you want to issue some SQL commands to your database engine without the graphical MS MSQL server interface?
If so, creating and modifying a stored procedure on a database engine which supports it is just a textual request, as with all other requests. It just have to respect the SQL syntax supported by the database engine:
CREATE PROCEDURE WhatACoolName ...
If not, then you wil have to rephrase your second question.