HomeworkLib
Question

How to run an SQL file to access the data in a different SQL file? They're...

How to run an SQL file to access the data in a different SQL file? They're separate but the tables are 1 file and the queries are in the 2nd file

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

You need to connect first, then run your .sql file in the wrapper script using the '@' sign or 'START' commands:

This should go in first.sql file
...
-- Connect if not already connected.
CONNECT username/password@database

@second.sql

...
0 0
Add a comment
Know the answer?
Add Answer to:
How to run an SQL file to access the data in a different SQL file? They're...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • What is SQL? How is SQL like an Access query? How is it different? Why might...

    What is SQL? How is SQL like an Access query? How is it different? Why might an accountant or auditor need to be familiar with SQL? Accounting Information System

  • You are given a database in a MS Access file called ‘DBP-e14-Cape-Codd’ that contains data collected...

    You are given a database in a MS Access file called ‘DBP-e14-Cape-Codd’ that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will help them grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2,… Please submit the MS Access and MS Word to help speed the grading turnout! in Blackboard. (to...

  • Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to...

    Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to retrieve all the data field from db_pvfc12_std in table CUSTOMER_T 2.- Run a query to retrieve record --> CustomerID = 11, How many records did you get and why? 3.- Run a query to retrieve all the data field from table Order_T               Once retrieved:                              3.1.- Please name the fields showing: Primary Key, Foreign Key and other fields                              3.2.- What type of...

  • how to make SQL CREATE TABLE in Microsoft Access? how to make SQL INSERT in Microsoft...

    how to make SQL CREATE TABLE in Microsoft Access? how to make SQL INSERT in Microsoft access? please answer by giving step by step

  • A(n) __________________ is a logical connection between rows in two tables where data in one table...

    A(n) __________________ is a logical connection between rows in two tables where data in one table references data in another table. The SQL ________________ statement removes a table from a database. The relational algebra "restrict" operator selects only the rows from the input table(s)  that satisfy a condition expressed in the _________________ clause. The SQL/PL ______________ command is used to re-direct the output of a script file to a text file. The ________________________ join creates a result set that includes the...

  • 1-Queries in Access are utilized by users to enter data into tables and view existing records....

    1-Queries in Access are utilized by users to enter data into tables and view existing records. True False

  • Microsoft Access 2013. Possible to attach the database here ? Make a list of at least...

    Microsoft Access 2013. Possible to attach the database here ? Make a list of at least two different queries you could create related to this event database. Remember that you can run queries on a single table, or, because these tables are joined in relationship, you can run queries based on multiple tables. One of the two queries should be a multiple-table query. Your query list should include-type of query ( I.e simple query, exact match, parameter, cross tab, etc),...

  • Explain how CIA can be achieved down to the folder and data file access level for departments and users using Active Dir...

    Explain how CIA can be achieved down to the folder and data file access level for departments and users using Active Directory and Windows Server 2012 R2 access control configurations. Configuring unique access controls for different user types is an example of which kind of access controls?

  • Complete the following using Microsoft® SQL Server® 2016: Write SQL scripts in Microsoft® SQL Server® for...

    Complete the following using Microsoft® SQL Server® 2016: Write SQL scripts in Microsoft® SQL Server® for OLTP that include: A Data Definition Language (DDL) script creating the four tables with appropriate data types, primary and foreign keys Data Manipulation Language (DML) scripts that insert a minimum of five records into each table Select scripts showing the full contents of each table Write and run a test script for Step Two. Save a screenshot of the results. Create a 6-page Technical...

  • Hi Please help me ASAP need SQL commands only for MS Access The following tables provide...

    Hi Please help me ASAP need SQL commands only for MS Access The following tables provide a very small portion of the data that will be kept in the database. The data needs to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 47. (If required by your DBMS, be certain to save the rows permanently.) only for MS Access!!!

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT