this tutorial is createing stored procedure in sql server with definition. You can get all concept of sql server in this playlist.