Jason Kleban
Jason Kleban

Reputation: 20758

Can an SSMS add-in have access to a resultset?

Can an SSMS add-in have access to resultsets? I would like an add-in tools menu item that can generate into the clipboard a DECLARE @Result1 TABLE ( ... ) (including the name, type, length, precision, etc) for each of the results in the most recently returned resultset. I see some discussions about accessing the result Grid UI directly, but by then some of the metadata would have to reconstructed from the grid values rather than from the resultset directly.

It seems to me that such an add-in would be useful when intermediate results need to be captured into an intermediate value for reuse, not having to go look up all those column types from all the joins.

Upvotes: 1

Views: 88

Answers (0)

Related Questions