• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

Check the compatibility of data type of append query!

i have append query where some data is filled to another table. But in the table which is filling the data is shown as query name (not table name)
 
 i need to check the compatibility of data types.. how i can check this?
 
 
0
jaisonshereen
Asked:
jaisonshereen
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
The query will inherit the data types of the table.columns that it is reporting on.
To 'check the compatibility', manually determine the data type of the source, and compare it to the destination.

It's generally not a good idea to be dependant on some kind of automated compatibility.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now