It could be useful to wrap the result of a select statement into a table valued function (inline or multistatement)6 votes
I would like to have template(s) for "Encapsulate as new stored procedure". for example I use
IF OBJECT_ID('dbo.SPName, 'P') IS NOT NULL
DROP PROCEDURE dbo.SPName
CREATE PROCEDURE dbo.SPName
WITH ...2 votes
give the option to encapsulate a piece of code like a subquery into a view so it can be reused , and give an option to create indexes on the resulting views as to max speed to the query1 vote
- Don't see your idea?