Published by: Jivan (8/18/2008)
I want to update a table but the records are huge so here is case i have to delete all and insert. I guess if i delete all and lose the connection before insert then i might run into issues. What you suggest me to do? Should i just insert first and record the ids to delete in the next query?
Comment (0)
Published by: San (8/16/2008)
I was looking forward to design a database which can handle 10 levels of category and that should be fast to browse through. I am having tough time in designing such a database. If you have any tips to get me a hold on it then please pass on here.
Comment (0)
Published by: Matt (8/16/2008)
I was trying to insert a record and fetch the id in same query, i don't know the best way but i don't want to make this in 2 querries. Can you guys help me in getting the result?
Comment (0)
Published by: Vivek (8/13/2008)
I have an existing database from where i want to export some data through a text file to the new database which is running on a different box. How do i transfer my data? Please help me if you can.
Comment (0)
Published by: San (2/6/2008)
I have an asp file where I have to copy few rows from a table and insert in the same too. I don’t want to make 2 queries by reading through the first then insert through the second query. If you know any way by which I can make a read and write in the same query then please post your comment.
Comment (0)
Published by: San (1/31/2008)
I have some sql queries written for SQL Server 2000 but these join queries are not working on Access database, anyone here who can guide me to change the query syntax or advice the right one to write.
Comment (1)