In SQL 2005 we could write something like this:
declare @i int
select @i = dbo.udf_MyScalarFunction()
exec usp_MyStoredProc @i
In SQL 2008 we can write the same functionality more succinctly like this:
declare @i int = dbo.udf_MyScalarFunction()
exec usp_MyStoredProc @i
Wouldn’t it be nice if, in the future, all we had to write was this:
exec usp_MyStoredProc dbo.udf_MyScalarFunction()
?
If you agree, feel free to vote for it and add a comment.