1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
juin [17]
4 years ago
7

What is the difference between a stored procedure and a user-defined function? Based on the Academic Database, identify and desc

ribe a scenario where it would be necessary to use a stored procedure or a user-defined function. Your answer should be addressed in 100 to 150 words.
Computers and Technology
1 answer:
bulgar [2K]4 years ago
6 0

Answer and Explanation:

<u>Stored Procedure</u> : It is an object that is pre-compiled. It seems to be the initially compile as well as those files are saved. It executes that compilation file while this has been called.

<u>Functions </u>: Through, when the function is called it is compiled as well as executed.  

<u>The differences between the both is that</u> -  

  • Stored Procedure return null, singular, or various values while Function only return one value at a time.
  • Transactions cannot used in the function but it can be used in stored procedure.
  • Functions may be named from such a stored procedure, but still not likewise.
  • Stored procedures may have an input or output arguments, but the function still contain arguments for input.
  • With the Academic Database situation, this is useful to use saved protocol anytime you choose to update / delete a participant, course, teachers, etc. Stored procedures are useful where the information or tables layout is to be altered.
You might be interested in
Reversing the elements of an array involves swapping the corresponding elements of the array: the first with the last, the secon
Alja [10]

Answer:

// Assume that all variables a, n, temp have been declared.

 // Where a is the array, n is the array length, temp is a temporary

 // storage location.

 // Cycle through the array a.

 // By the time the loop gets halfway,

 // The array would have been reversed.

 // The loop needs not get to the end of the array.

 // Hence, the loop ends halfway into the array i.e n/2.

 for (int k = 0; k < n / 2; k++) {

   

  // Swap first and last, second and next-to-the-last and so on

  temp = a[k];

  a[k] = a[n - k - 1];

  a[n - k - 1] = temp;

 }

Explanation:

Explanation has been given in the code in form of comments. Please go through the comments in the code carefully.

Hope this helps!

6 0
3 years ago
How Can I add a image in an HTML program?​ please tell
Doss [256]

Answer:

use the img tag

Explanation:

First of al, HTML is not a program, it is a markup language.

To add an image, use:

<img src="...url to the image...">

8 0
3 years ago
Mary is writing an article about the animal kingdom. She wants to place an image below the text. Which menu should Mary choose f
lakkis [162]

Answer:

The answer to this question is given below in the explanation section.

Explanation:

This question is about how to insert caption or text below the image. Marry have to follow the following steps:

  1. Open the article in MS Word
  2. Select the image to insert the text below it.
  3. Then go to the References menu
  4. Under the reference group, click on the insert caption button
  5. a popup, windows will get open, fill in it the required detail.

If you want to insert the image below the text, then you have to follow the following option.

  1. Select the text where you want to insert the image
  2. Go to insert men
  3. Under the Illustration group of menu, click on pictures button, or online pictures button and select the image and click ok.
5 0
3 years ago
In what decade did the Internet begin to be used widely by the public and not just government entities?
Allisa [31]
In the 1980's the internet was open to the public
But it wasn't until the 2000's that it started to be widely used
Your answer is C 2000's
3 0
3 years ago
Read 2 more answers
Why do all the people are mean, why report my answer even when it is correct and the reason would i have violated their terms .
Alexxx [7]

Answer:

Sometimes annoying people get bored and decide to report random things for no reason. it sucks. sometimes people accidentally press the report button when they didn't mean to, I did that once and i felt really bad. There should be a "are you sure you want to report this" button when you hit the report button. It would help.

Explanation:

7 0
4 years ago
Other questions:
  • Which of these statements regarding mobile games is true? A. They are typically played indoors. B. They have detailed environmen
    7·1 answer
  • Create a website for an online movie rental store, using HTML (and any other client technologies) and PHP. The website should in
    8·1 answer
  • You have just started an internship on a graphic design team and you are learning about graphic formats used on the web. Which o
    9·1 answer
  • Guided transmission media employ an antenna for transmitting through air or vacuum.
    9·1 answer
  • Which element is located on the top left of the Word screen?
    6·1 answer
  • Difference between server and a client computer
    7·1 answer
  • Cú pháp câu lệnh xóa thủ tục
    12·1 answer
  • Question #1
    5·2 answers
  • What three actions happen when you cloak a folder or file?
    6·1 answer
  • What are the two main parts to a VR experience.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!