What are the challenges you face when working across database platforms? Take the survey
Options

Possible? Maybe a new feature!

Hi

I am in the process of converting many Stored Procedures to UDFs (for various reasons).

One thing that is irritating is that these SPs often use the SELECT x, y, z INTO #tempTable pattern.

Would that be possible for you to generate the equivalent DECLARE @tempTable TABLE ( x TYPE,y TYPE,z TYPE) statement?

That would have proven to be very helpful!
Tagged:

Answers

Sign In or Register to comment.