Breaking News: Grepper is joining You.com. Read the official announcement!

sql data type of query

Add Answer

dr4ft answered on March 2, 2020 Popularity 10/10 Helpfulness 1/10

answer sql data type of query

related checking data type in sql server

related sql data types

related sql select data type of query

sql data type of query

Comment

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

Popularity 10/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 16 2022

dr4ft

0 Answers Avg Quality 2/10

Closely Related Answers

checking data type in sql server

Comment

SELECT COLUMN_NAME,
       DATA_TYPE,
       IS_NULLABLE,
       CHARACTER_MAXIMUM_LENGTH,
       NUMERIC_PRECISION,
       NUMERIC_SCALE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name';

Popularity 10/10 Helpfulness 4/10 Language sql

Source: bigdata-etl.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jun 27 2021

0 Answers Avg Quality 2/10

sql data types

Comment

# Numeric Types
BIT	TINYINT SMALLINT INT BIGINT DECIMAL NUMERIC FLOAT REAL

# Date & Time Types
DATE TIME DATETIME TIMESTAMP YEAR

# Char & String Types (N) Denotes Unicode Versions
CHAR VARCHAR TEXT NCHAR NVARCHAR NTEXT

# Binary Data Types
BINARY VARBINARY IMAGE

# Misc
CLOB BLOB XML JSON

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.journaldev.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 02 2020

Kaotik

0 Answers Avg Quality 2/10

sql select data type of query

Comment

SELECT x.* INTO TMP1
FROM ( SELECT TOP 1 /* rest of your query expression here */ ) as x;

SELECT o.name AS obj_name, TYPE_NAME(c.user_type_id) AS type_name, c.*  
FROM sys.objects AS o   
JOIN sys.columns AS c  ON o.object_id = c.object_id  
WHERE o.name = 'TMP1';

DROP TABLE TMP1;

Popularity 7/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: select sql

Link to this answer
Share Copy Link

Contributed on Mar 31 2022

dr4ft

0 Answers Avg Quality 2/10

sql data type of query

Contents

More Related Answers

sql data type of query

Closely Related Answers

checking data type in sql server

sql data types

sql select data type of query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.