Hello,
I need experts advise...I've an ASP page which is retriving 10,000 database records and it's taking too long to execute.
how do I make it faster.
I used response.buffer=true and response.flush methods but no change.
Thanks in advance.
Hello All,
How do I create auto number in SQL Server (similar to autonumber in MS-Acces and generating a sequence in oracle). In my code I have a field Emp_No which needs be generated automatically every time we insert a record in to the table.Any help is appreciated. thanks in advance.
Hi ,
I've an ASP page which is retrieving all the records from the database. I would like to provide an option to the users that they can edit any record and save the changes in to the database. How do I write dynamic update statement to update that particular record user choose to edit.
Any...
How do I install Xppro with out upgrading from XP home? I already upgraded from XP home to XP pro, but having problem with Intenet connection. Now I would like to cleanup my laptop and install XP pro. I've only one partition (C Drive) and I'm very much new to formating the disc. Any help is...
I've an assignment in which I've to write an ASP Script to import data from Excel sheet. I've never done this before, could anyone help me with this.
Thanks.
markallen2 & bilsten,
I tried everything, but I couldn't rectify the problem. I would really appreciate if you could help me out with this problem.
Thanks.
I've AOL & MSN. When I use AOL the moment I login it says "error occured in your intenet connection, exit the application and restart". When I use MSN it doesn't even allow me to login, says "unable to provide MSN service/error in your system".
I tried to setup new...
Hello All,
I did upgrade from XP home to XP pro on my notebook. I don't know what's wrong with it, I'm not able to connect to the Internet since I upgraded. Can somebody help me with this problem.
Thanks in advance.
Hello All,
I'm trying to create a login page with Username listbox,password and I have a table which is storing the records for Username and pwd. I'm loading the username values into listbox and when I'm typing the password I want to check with the corresponding password in the database.
Any...
Hello All,
I've been writing Oracle triggers, but I'm very much new to SQLServer. Can some one help me in writing Triggers in SQLServer, is it similar to Oracle.
I'm trying to witre a gtrigger on table called TRUCK,when TRK_IS_ACTIVE='F' I want to update the field TRK_STOP_DATE to SYSDATE...
Thanks Allan,
I'm able to create a trigger with your help. But when I'm trying to update the table it's giving me an error.
ERROR at line 1:
ORA-04091: table KEITH.CREW is mutating, trigger/function may not see it
ORA-06512: at "KEITH.BU_R_ON_CREW", line 3
ORA-04088: error during...
I'm trying to witr a gtrigger on table called TRUCK,when TRK_IS_ACTIVE='F' I want to update s field TRK_STOP_DATE to SYSDATE.
CREATE OR REPLACE TRIGGER UPDATETRUCK
BEFORE UPDATE OF TRK_IS_ACTIVE ON TRUCK
BEGIN
IF TRK_IS_ACTIVE = 'F' THEN
UPDATE TRUCK SET...
Hello All,
I'm trying to install Visual Interdev on WinXp home, but it's not opening the application. As soon as I open any application with Interdev, it's closing the window.
I'm wondering whether I need to have any webserver to work with interdev (I don't have IIS or Apache webserver) on Xp...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.