mardi 24 février 2015

How to determine the data type of all fields in a result set in SSDT?


I'm writing a table valued function in SQL Server Data Tools (SSDT). Table valued functions require you to explicitly state the data type of the returned table. In my particular case, I've written a query which returns the values that I want. I can execute it using SSDT, but can't figure out how to quickly determine the data type of the columns returned.


Is there a way to get the list of columns that it returns and the data types of said columns so I can quickly and accurately populate the list of columns in the ReturnTable?


The closest I've gotten is to hover over the field name in the SELECT clause, but that doesn't provide the length or precision limitations.


enter image description here





Aucun commentaire:

Enregistrer un commentaire