Explore BrainMass
Share

SQL Scripts for Data Manipulation

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I do not understand how to provide scripts that would build tables, insert data and query data from tables. Please get me started with this and I will add the data if someone can get me in the right direction. Our instruction states, "Bypass the Oracle Database requirement and only provide
scripts that simulate the activity required by the assignment.  Hopefully this will eliminate the frustration typically encountered with trying to gain
access to the Oracle database.   If you elect this option, you should provide the scripts that you "would" execute to build your tables, insert the data, and query data from the tables."

Also this is project 2 of our assignment. To give you an idea of this assignment, attached is project one which I have completed several weeks ago.

© BrainMass Inc. brainmass.com October 25, 2018, 7:02 am ad1c9bdddf
https://brainmass.com/computer-science/sql/sql-scripts-for-data-manipulation-488041

Attachments

Solution Preview

I believe what you are looking for are SQL scripts that would do the building of table, inserting of data and querying of data. These scripts are simple text files and are usually saved with the extension .sql. See my examples below of scripts that do those three things.

Create Table - This script would create a table called ...

$2.19
See Also This Related BrainMass Solution

Data Manipulation and Monitoring

What do you feel is the best strategy for monitoring the performance of your SQL Server 2000 installation? What hardware components are involved in successful monitoring of a database installation? What can be done within the database itself to increase performance? Be sure to cite your sources.

View Full Posting Details