I want to know the SQL result set with DataType

Question

1.00/5 (1 vote)

See more:

SQL result set is not match with asp.net, but I can't able to find the mismatch datatype, can you help me to find it.

I want to know the data type with SQL result.

Posted 8-Feb-15 17:59pm

Member 11233725

Add a Solution

Comments

virang_21 9-Feb-15 0:13am

Please post part of the source code that is causing issue.

[no name] 9-Feb-15 0:16am

I want to know the datatype from the SQL query result set.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-02-08T18:25:00

Why don't you check manually the datatypes of the columns those are present in the select list? That would be the simplest way to do this.
I don't think there is any direct way to know the datatype of the columns in the result. But you can find the datatype of columns a table by following query

SQL

SELECT Col.NAME [COL NAME],Typ.NAME [DATA TYPE]
FROM SYS.COLUMNS Col
INNER JOIN SYS.TYPES Typ ON Col.USER_TYPE_ID = Typ.USER_TYPE_ID
WHERE Col.OBJECT_ID = OBJECT_ID('YourTableName')

Hope, it helps :)