0
Data Source
Wiki User
∙ 14y ago
Wiki User
∙ 12y agoData source
Add your answer:
Earn +20 pts
What table or tables from which a query gets its data?
You'll have to do it.
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...
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
What is duplicate data?
Data duplication is the process by which multiple rows of the same data gets inserted into a database. For example consider the employee table Employee Name Emp Num Age AAA 111 20 BBB 222 22 If we insert another row with data "AAA 111 20" Then it would cause data duplication.
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.
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.
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.
If I use a console table behind my sofa, how high should it be in relation to the back of the sofa?
For the most part the sofa table is tawords the top of the sofa. However, it also depends on what you want. If you don't want too much showing over the sofa, get one that is a little lower that is mid sofa(gets harder if you have a short sofa).
