Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-
I get the above error. I know the code can be easily rectified by doing:-
It just makes the code read bad and perform bad as you would need to add this system function call everywhere you insert into the return table. One line instead of 5 makes more sense to me!