Question

This week, we will drill into SQL SQL queries. For this discussion, create a two tables of your choice in SMSS and then insert a few records into each. Show your CREATE table and INSERT queries. Then, using SELECT: 1. Select a COUNT of the number of records in each table. 2. Select all records from the table. 3. Select specific fields from the table. 4. Select specific fields from the table using a where clause that specifies a desired condition. Show your SELECT queries and results. Finally, discuss when you might index the table and describe how you would create the index.

          This week, we will drill into SQL SQL queries. For this discussion,
create a two tables of your choice in SMSS and then insert a few
records into each. Show your CREATE table and INSERT queries.
Then, using SELECT:
1. Select a COUNT of the number of records in each table.
2. Select all records from the table.
3. Select specific fields from the table.
4. Select specific fields from the table using a where clause that
specifies a desired condition.
Show your SELECT queries and results.
Finally, discuss when you might index the table and describe how you
would create the index.

This week, we will drill into SQL SQL queries. For this discussion,
create a two tables of your choice in SMSS and then insert a few
records into each. Show your CREATE table and INSERT queries.
Then, using SELECT:
1. Select a COUNT of the number of records in each table.
2. Select all records from the table.
3. Select specific fields from the table.
4. Select specific fields from the table using a where clause that
specifies a desired condition.
Show your SELECT queries and results.
Finally, discuss when you might index the table and describe how you
would create the index.

Added by Robert B.

Question

Please give Ace some feedback