I need to write some queries for a project. I would need SQL code for these func

Question

I need to write some queries for a project. I would need SQL code for these functions:

Search
New/Add
Remove
Edit
Reports

Example of what I need:

Function 1: List all the customer information
Query: Select * From Customer;

Here is some more information about the project:

Below is the home screen which is shown after the user login, giving the user a number of options to choice from which include: Add/New, Edit, Remove, Report and Search. Each screen will generate a different page which serve its own function to the database.

-The Search page which gives the user the option to search the database for a specific keyword, also having the option to narrow the search with a dropdown box, restricting the search fields.

-The Remove page, giving the user the power to delete a piece of data from the database, before which, a pop-up will appear as a confirmation to delete the data

-The Report page which gives the user the ability to generate a report on the data within the database and further export that data to an Excel spreadsheet to perform further analysis on.

Explanation / Answer

search:

select * from customer;

add/new:

insert into customer

   values(54,'name',457,621);

remove:

delete from cutsomer

where custmer name='name' and cantcat name='name';

Edit:

update Customer
set City='city name'
where CustomerID=1;

reports:

select customer

from v_FullCollectionMembership

where CollectionID = 'id'

these all are example querys because i dont your table name and table details.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects