sql server select query datatype
--Microsoft SQL Server 2019
DECLARE @query nvarchar(max) = '
SELECT TOP (1000) [id]
,[name]
,[lastname]
,[age]
,[createdate]
, cast(createdate as date) as data_date
FROM [Z_Test].[dbo].[userDemo]
';
EXEC sp_describe_first_result_set @query, null, 0;