Data Tables

Mysql syntax

Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work :|… Any suggestions.... ? ...

Effective ways for retrieving millions of records from a table?

I have two tables -- [em]Users[/em] and [em]UserAddress[/em] -- with 30 million records in each. Software/Hardware used: SQL Server

Add a row from DataTable to second DatTable

Hello, I have a DataTable that gets new data in loop, each time the data is changed I want to enter the new row to second DataTable (that in the end of the loop will contain the whole data). Here is my code and my problem is in the end: //ReminderDetail - the DataTable that is changed in loop...