diff. b/w UPDATE&APPEND query.?

Question

i know the basic answer but this is my 5 marks question so i need atleast few points of differentiation.

Answer 1

Here goes an answer for 5 Marks.



Update:

- This is an query used for data manipulation.

- For updating any query you need to move the pointer to the specific location.

- It is helpful in correcting the errors made in insertion or to change any information without deleting the record fully.

- The storage location of the data doesnt change in update.



Append:

- It is an data Insertion query.

- Data/Record are inserted at the end.

- The pointer moves directly to the location, EOF-1. EOF is End of file and it is an Pointer which specifies that there is no more data available and this is the termination point in any file.

- Helpful in entering New record without moving the file.



I think this may give u atleast 4 marks.

Hope you are satisfied with this....please do tell me about any change which are suggested you by the person who is going to check this answer.

Thank You

Answer 2

In update query you change the existing records whereas in append query, you add a new record



The record count does not change in update query, but in append the record count gets added



there is a posibility of data loss if you over write an existing record, but in append query, you do not change the existing record and just add additional data to a new record.



Hope this is Ok!

Answer 3

Append creates a new record, update works on an existing record.



Append creates a new record at the end, update just changes the last modified time stamp of the record

Answer 4

Crosstab question is likewise noted as pivot question. that is a change of rows of documents to columns. it in many cases includes aggregation of documents. enable's have an party to exhibit what it does: table shopper: shopper identity | quantity | Date a million one hundred 06/22/2006 2 2 hundred 07/26/2006 3 one 0 5 08/28/2006 in case you want to well known how a lot you earned in each and each month and the outcome feels like this: Month2006_06 | Month2006_07 | Month2006_08 | finished one hundred 2 hundred one 0 5 405 we are able to get the outcome by technique of creating use of crosstab question as shown belows: go with SUM(CASE at the same time as Date between '06/01/2006' AND '06/31/2006' THEN quantity ELSE 0 end) AS Month2006_06, SUM(CASE at the same time as Date between '07/01/2006' AND '07/31/2006' THEN quantity ELSE 0 end) AS Month2006_07, SUM(CASE at the same time as Date between '08/01/2006' AND '08/31/2006' THEN quantity ELSE 0 end) AS Month2006_08, SUM(quantity) AS finished FROM shopper the position DATE between '06/01/2006' AND '08/31/2006' ** word: that is an truly user-friendly question. notwithstanding it would tell the mandatory concept about flow/pivot question. wish this facilitates.