The best replacement for stored procedure is view.

The best alternatives to stored procedure are rated as following:

★★★★★	view
★★★★★	function
★★★	trigger
★★	linq
★★	inline sql
★★	dynamic sql
★★	query
★	user defined function
★	prepared statement
★	table valued function
★	function oracle
★	functions
★	sql query
★	orm
	entity framework
	udf
	code
	function mysql
	views
	function which is faster
	ssis
	function sql server
	package
	dynamic sql performance
	web service
	stored function
	sql statement
	standard query
	jdbc

Your alternative for stored procedure is not listed? Suggest!

Speaking about stored procedure, one probably shouldn't forget about output parameter.

Other search terms related to stored procedure and their ratings are:

★★★★★	output parameter
★★★	return value
★	parameter
★	output parameter in sql
★	begin end
★	input parameter in oracle
	output parameters
	multiple output parameters

You have in mind a companion for stored procedure and it is not yet here? Propose!

Google Trends

Scale is based on the average worldwide traffic of stored procedure in all years. Click on graph for more.

stored procedure

view

function