Sql select statements

[ Team LiB ] Recipe 4.14 Overcoming Keyword Conflicts When Using CommandBuilders Problem Your data includes table and column names that conflict with SQL keywords. You can overcome this with brackets or quotes in SELECT statements that you write, but the CommandBuilder creates illegal update statements.

4p luvpro 04-08-2010 75 4   Download

Figure 3.6: Products where ProductName is like 'Cha%' The next SELECT statement uses the LIKE operator to retrieve products where the ProductName column

9p daisuphu 29-07-2010 63 4   Download

Figure 3.16: Using the DISTINCT keyword to retrieve distinct Country column values As you can see, the SELECT statement only displays Country column values that are unique: duplicate values are eliminated.

11p daisuphu 29-07-2010 79 3   Download

The Fill() method then creates a DataTable in the DataSet with the specified name and runs the SELECT statement. The DataTable created in your DataSet is then populated with the rows retrieved by the SELECT statement.

5p daisuphu 29-07-2010 94 5   Download

Performing a SQL SELECT Statement and Storing the Rows Locally In the example featured in this section, you'll see how to connect to the SQL Server

4p daisuphu 29-07-2010 90 7   Download