Stored Procedure

[Rhys]

Hi,

It would be good if the reversal process from SQL 2005 now allowed for the new user type Max with respect to stored procedures. As now there are such types as varchar(Max) etc as well as what EA can currently reverse engineer as varchar(100) etc.

Rhys

[«Midnight»]

I don't think this is a data type so much as some kind of internal function that we can treat like a constant. (Think of it like a maxint sort of thing.) It could also be addressed as a keyword.

That said I agree that Sparx should take a look at it. MS has used this approach to get out of the "this overload of the signature is for 64-bit implementations" that we've seen in pre-2005 products (not just SQL Server). We'll be seeing much more of this, and it will likely be pervasive in core products and libraries from MS and other tool vendors.