Solving the problem of deleting the table
State the steps for “this message could not delete” from the particular tables?
Expert
This error is caused due to the delete query and when unique property is set to “no”.
Following given are the steps that must be followed in order to solve the problem.
1) Delete query must be opened and if it is not opening then press F4.
2) Clicking on the query properties underneath query designer will provide you the options.
3) In that options, you require to locate the unique records property and must set it to yes. These options are present in the query property sheet.
Explain about the stored-procedures and its advantages.
Briefly describe the capabilities and concepts of Business Intelligence?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
What is meant by the term query subject?
Explain, what are Dimensional table?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Illustrate the term indexing. Specify the kinds of the indexing.
Give a brief introduction of the term Dimensional Modeling?
Describes the difference between NULL and VOID pointers into Data Structures?
Explain the Scope of Analysis?
18,76,764
1952243 Asked
3,689
Active Tutors
1419651
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!