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.
Aucun commentaire:
Enregistrer un commentaire