Sql

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_NAME = 'yourTableName' AND 
     COLUMN_NAME = 'yourColumnName'

DECLARE @query nvarchar(max) = 'select 12.1 / 10.1 AS [Column1]';
EXEC sp_describe_first_result_set @query, null, 0;

PREVIOUS	NEXT

Code Example
Sql :: uninstall mysql ubuntu 18.04 stackoverflow
Sql :: t sql dynamic top n query
Sql :: identify primary key in oracle table
Sql :: auto increment in postgresql
Sql :: declare or use variable in snowflake
Sql :: select the date 30 days less that the todays date sql request
Sql :: psql get last rows
Sql :: oracle generate list of dates in between a date range
Sql :: mysql select or insert current datetime
Sql :: difference between 2 query results sql server
Sql :: smallint sql
Sql :: temp tables in sql server
Sql :: mysql in
Sql :: mysql fetch all data
Sql :: postgresql create table as select
Sql :: mysql update command
Sql :: PostgreSQL: To_Number function
Sql :: sql server order by nulls last
Sql :: mysql:5.6 syntax create table
Sql :: mysql two joins
Sql :: how to filter repeated same result using sql query
Sql :: SQL order by string split length
Sql :: export mysql database command line
Sql :: sql select
Sql :: sql limit to 5 results
Sql :: how to select multiple columns from different tables in mysql
Sql :: what is unique key in sql
Sql :: add sqlite3 in lumen
Sql :: sql not equal to operator
Sql :: SQL division of an integer by another integer get float CAST