I five hundred number, I want to query the database to see if there is, there are in the query times wrong, there are too many number, how can find?

CodePudding user response:

Using tools to generate a new table to import, then a federated query

CodePudding user response:

Have a table alone, the number 500 to be imported into, and then left the join query, for there is no air in the house of representatives, pay attention to add number column index

CodePudding user response:

Either with a stupid way, the first to get to the 500 number, and then use the where... or... Splicing SQL string in circulation, or use the ORM, use Linq query in memory, as for use in error, you said because you didn't post code so to say, but it is possible that your SQL writing has a problem,

CodePudding user response:

A too much apart, points 2 times "is 10 times, more simple

CodePudding user response:

Using LINQ, intersection,

CodePudding user response:

reference 5 floor shijies reply:

use LINQ, intersection of

,

How is the specific? Can provide an example

CodePudding user response:

Product description when problems have wrong character, so I doubt you have a problem to write SQL.
First check your code, or post your code to see.