answersLogoWhite

0


Best Answer

Typically you would do a SELECT statement for the table that contains the product list. The details depend on the names of the table, of the fields, and of the information you know; for example if you know that the product description is "xyz", you could issue a command similar to the following:select * from ProductList where ProductName = "xyz";


User Avatar

Wiki User

8y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How would you find a certain product number in a database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How would you find a certain product number?

You can contact the manufacturer or distributor - either by phone or through their on-line catalogues.


What is the difference between database application and dbms?

A DBMS is a database management system. A database application would be something inside the DBMS such as: ~a way to search files ~a way to pull certain information


What is the product of 3 less a number?

This would just include one number in the question, which would not make a product.


What is product of six and a number?

The "product" is when you multiply things together, so the product would be 6 x "a number"


For the purpose of DSN we have to specify a database name so how do we give a name to a database?

The same you would to any other file. Consider the purpose of your database, what you are using it for, what data you are compiling. Think about what product you are producing, what the central idea of the file is. That is your name.


What are some examples of a primary key?

In a database a primary key is a unique value, meaning that it cannot be repeated. It is also mandatory, so it cannot be left blank. Something like a product code, an ISBN number, a student number, an employee number etc. would be primary keys.


What would you call a promise to repair or replace a faulty product within a certain period of time?

product liablility


What does a database contain?

A database contains structured data organized in tables to store and manage information efficiently. It typically includes fields for different data types, rows for individual records, and relationships between tables to establish data integrity. The data can be retrieved, manipulated, and queried using database management systems.


Why would you use database?

why would you use database?


A telephone number would be stored in a field in a database?

You can save it in NUMERIC or varchar datatype.


What is national criminal database?

A national criminal database is a centralized repository of criminal records and information that is maintained by a government agency. It typically contains information on individuals who have been arrested, charged, or convicted of a crime within a specific jurisdiction. Law enforcement agencies and other authorized entities use these databases to access and share information about individuals' criminal history.


What is the product of 72 and a number?

If x is used to represent the unknown number, the product of 72 and a number would be written as 72x.