You need to select one row at a time from a cursor table - and preform...

Question

Question

You need to select one row at a time from a cursor table - and preform...

You need to select one row at a time from a cursor table - and preform an appropiate action after which sql construct do you use?

a. cursor loop

b. t-sql function

c. t-sql procedure

d. trigger

e. while loop

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

a. cursor loop

Add a comment

Answer 2

Similar Homework Help Questions

Hi good day i need homework help fast please d32 1./What is the maximum length that...

Hi good day i need homework help fast please d32 1./What is the maximum length that a VARCHAR data type can be: a. 65535 b. 1023 C. 255 d. 32767 2.) Why are alias' used for table and columns? a. to make the names easier to understand b. to hide the column or table c. to be able to remove them from the database d. to give the appearance that they are new- 3.)What does the FIELD function allow you...
You're building a database that tracks inventory & sales at the company you work for. Every...

You're building a database that tracks inventory & sales at the company you work for. Every time a row is INSERTed into the OrderLines table, you need a process to be invoked that checks the inventory table to make sure the particular Product is in stock.if the product is out of stock, the Quantity on the row should be changed to 0 indicating there were non in stock for the Product. You have chosen not to put this logic into...
For Microsoft Access Define the four types of Action Queries: Make-table, Update, Delete, Append What is...

For Microsoft Access Define the four types of Action Queries: Make-table, Update, Delete, Append What is an index? What field is automatically indexed? Advantages and disadvantages? What is a macro? An action? An argument? What is a command button? What are events? Event properties? Examples of event properties? What is a submacro? How is it represented in code? Why are the InputBox function and GoToControl action useful for the FindRecord action? What is the ExportWithFormatting action typically used for? What...

i need help with this homework web page and i need the code too Using the "do while" or the "for" contr...

i need help with this homework web page and i need the code too Using the "do while" or the "for" control statements, have a visitor to your Web page do, or see, something repeatedly. You could have him or her enter a number of months, an interest-rate, and an amount, and print out a table with the amount on deposit. Try to make the loop appropriate to the website theme that you have picked. Use a function in your...
A) You need to do ONE thing in this MarvinJS editor. Draw the electron flow arrows...

A) You need to do ONE thing in this MarvinJS editor. Draw the electron flow arrows showing the step where the benzene derivative participates in the reaction that leads to the final major organic product. B) Draw the skeletal structure of the major organic product. The deuterium isotope (D) must be shown explicitly. C) Draw ALL the resonance structures needed to depict the arenium ion for this reaction. Include all lone pairs of valence electrons and all D's. PLEASE HELP!...
Select the BEST answer for each questió letter in the table at the right. I. For...

Select the BEST answer for each questió letter in the table at the right. I. For a parallel plate capacitor: C = : If & and A are constant, what would a graph of C vs. d look like? 2. What equation is used to determine the equivalent capacitance of three capacitors in series? b. ?., C, C, C, C C+C, +C c. C +C+C C C3 C It's a trick question. Capacitors cannot be connected in series. Kirchhoff's Loop...

1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code...

1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column. 2. Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the Category Name column to “Woodwinds”, and it should use the CategoryID column to identify the row. 3.Write an INSERT statement that adds this row to the Products table: ProductID:...
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named ge...

For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python...
The Table OR_LOG_TIMING_events had one row for each timing event documented in a log. You are...

The Table OR_LOG_TIMING_events had one row for each timing event documented in a log. You are writing a query that must have one row for each log, with each timing event in a separate column. The column TIMING_EVENT_C identifies which timing event is being documented, & the column Timing_event_DTTM is the time at which the timing event occurred. The column LOG_ID identifies the log on which the timing event was being documented. Timing_Event_c = 1-- represents the event for IN...

From the table of available reagents select the one(s) you would use to convert butanoic acid...

From the table of available reagents select the one(s) you would use to convert butanoic acid to each of the following products: (Use the minimum number of steps; from one to six are required. List reagents by letter in the order that they are used; example: fa. NOTE: Assume that a normal aqueous (or mild acid) workup follows each reaction; you do not need to add reagents for the workup.) Reagents Available a. benzene/AlCl3 d. H2O, H2SO4 g. LiAlH b....

You need to select one row at a time from a cursor table - and preform...

Homework Answers

Add Answer to:
You need to select one row at a time from a cursor table - and preform...

Post as a guest

Earn Coins

Hi good day i need homework help fast please d32 1./What is the maximum length that...

You're building a database that tracks inventory & sales at the company you work for. Every...

For Microsoft Access Define the four types of Action Queries: Make-table, Update, Delete, Append What is...

i need help with this homework web page and i need the code too Using the "do while" or the "for" contr...

A) You need to do ONE thing in this MarvinJS editor. Draw the electron flow arrows...

Select the BEST answer for each questió letter in the table at the right. I. For...

1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code...

For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named ge...

The Table OR_LOG_TIMING_events had one row for each timing event documented in a log. You are...

From the table of available reagents select the one(s) you would use to convert butanoic acid...

You need to select one row at a time from a cursor table - and preform...

Homework Answers

Add Answer to: You need to select one row at a time from a cursor table - and preform...

Post as a guest

Earn Coins

Add Answer to:
You need to select one row at a time from a cursor table - and preform...