Search results for query: *

Hi, I have a form that consists several buttons. One is to delete a table A, then add records to several tables and eventually it will do a join and insert records to table A, and display a report. It always works while all tables reside in the same Access database. Now we are trying to...

Is there a way to generate SQL Script for triggers, like the way we do for tables, views and sp?

Is there a way to get date and time in DOS? I tried "date". but it prompts me to set a new date. In fact, I want to write a batch script to copy a file with the current date and time as the filename (the latest file in a directory) to another network drive. This batch will be scheduled to...

My admin. just installed Windows Server 2003 and I moved one of my web applications from my development server to the new server. The web app. works fine on my local machine. But when I tried it on the new server, it said "File Not Found" and "HTTP Error 404 - File or directory not found."...

I wonder how to use UPDATE trigger and get the old value of some column before update. I need to insert that value to a table. I created a trigger but it doesn't return any value. I have the print statement but nothing gets printed. CREATE TRIGGER Test_Update ON Test FOR UPDATE AS DECLARE...