0
What else can I help you with?
The table or tables from which a query gets its data is the?
Data Source
How do you insert values in 2 tables by one query using SQL 2005?
You could create a trigger on one of the tables. A trigger is basically code that executes when a particular type of event occurs on a table. For example, you could have code that runs everytime data is inserted into table so it takes some of the fields, does some logic, etc, then inserts that data into table 2. The benefit of a trigger is that it gets "triggered" whenever a particular event occurs so it would get triggered if the data got inserted via a MS Access front end or a SQL 2005 tool, or some other application. Triggers are often used to populate audit table to keep track of who is adding/updating/deleting data in important tables.
What is the difference between Dynaset and snapshot in VB?
a dynaset object can be used to retrieve information from a recordset and use the resault of the query to then edit the records and it also can get resaults from more than one table. On the other hand the snaphot gets information from only one table on the query and the data can not be edited or updated
Why rownum equals 2 not work in oracle tables?
rownum returns the number to indicatin th sequence,it always returns sequentially no. 1,2,3 so when we fired query for row 1 select * from emp where rownum=1 then first it gets 1 and show the result. but,so when we fired query for row 2 select * from emp where rownum=2 then first it gets 1 and criteria is not match.
Why is it better to store data in multiple related table rather than one big table?
Basically to minimize redundancy (unnecessary repetition) of data in the database. By storing only information (fields) that directly relate to each other in each table AND modeling how the tables should relate to each other you also get the maximum flexibility in ways to retrieve information. A simple example would be a table to store INVOICES and a table to store CUSTOMERS. The INVOICE table only has information about an invoice; Inv#, Amount, Date, etc. and The CUSTOMER table information about customers; Name, Address, Phone, etc. An Invoice has one customer but a customer can have many invoices. If we give the customer a unique ID then, in the INVOICE table we need only store that ID (called a foreign key) but with it the database can look up the rest. So you dont store customer name, address, etc over and over again every time a customer gets a new invoice. The process of splitting up data into separate structures is called normalization. Often times data is de-normalized and repeating data allowed for performance or snapshot reasons.
Are Diamond ProAm tables as good as they say?
I think they are as good as it gets...
What tables do you not have to learn?
Depending on the job, you might have to know all the tables! As a student gets further and further into mathematics, there are more tables to memorize in order to save some time on math problems.
How do you populate values of combobox using server side scripting as php?
I am assuming you already have a mysql connection function/string in placeNow select the databasemysql_select_db("db_name"); // Put the name of your database in place of db_name// Add the column you want data from in place of ID// Add the name of your table in place of table_name$query = mysql_query("SELECT ID FROM table_name");// This gets a bit complicated but it helps with debugging?>Select an option
Where the table gets storage in oracle?
In Oracle, the table gets its storage space from extents, which get their storage space from tablespaces, which get their storage from datafiles.
What is the difference between a hot steam table and a hot food table electric or propane used in restaurants?
The purpose of a steam table is to heat food with steam. That is to say specifically from steam. Other types of hot tables will make use of water to keep food hot. The difference is that in a steam table the pans of food are not actually sitting in the water and can reach a higher temperature because steam gets hotter than water. Most tables employ the use of water heating the food directly, which will keep the temperature below 212F and heat the food more evenly. Both types of table can be either electric or propane fueled.
Does a water table gets low when more or less water is pumped out of it than is replaced?
Yes, when more water is pumped out of the water table than is replaced, the water table will drop. This can result in negative consequences such as decreased water availability for wells and surface water bodies, as well as potential land subsidence. It is important to manage water usage sustainably to prevent depletion of water tables.
What is data stored?
stored data is data that gets placed in different places on a computer but there is different types of stored data
