Data Connector and SQL WHERE clause to filter data

This article will give you a basic understand of the SQL WHERE clause. This will come in handy when you are setting up BoostSolutions Data Connector and for those who want to do more with Data Connector.

For those who are not familiar with SQL commands, a simple definition is necessary. SQL commands, which contain SQL clauses, are SQL code that makes an SQL application or server perform tasks within a database. SQL clauses are words or phrases that are part of a SQL command statement and tell programmers what the command will do to the database.

The SQL WHERE clause is designed to allow you to add a search condition or conditional statement, basically a filter, to a SQL statement and helps you to filter or limit data for easier searching. When the Data Connector job is run with a SQL WHERE clause the SQL searches through each row looking for data. When the condition is met (returns true) a row is returned as a result. Operators can also be used with the SQL WHERE clause such as =, <=, >=, <, >, IN, BETWEEN, and so on.

With Data Connector, you are connecting to your data. So if your organization happens to have a large number of databases then using a SQL WHERE clause will help you to get faster searches and more precise results. Say for example you have hundreds or even thousands of records. It makes no point to retrieve or update everything. So you can use the SQL WHERE clause to target the precise location and get back the right information faster and easier.

Resources:

http://msdn.microsoft.com/en-us/library/9hbceeb4(v=vs.80).aspx

Please email us if you have any comments or questions: inquiry@boostsolutions.com.

Leave a Reply