viki123
Last Activity: May 18 '10, 04:42 AM
Joined: Mar 9 '10
Location:
-
Export import error in sql server 2000
i hav 500mb csv file i want to export it in sql server 2000 i m unable to export pls help -
viki123 started a topic How to insert excel file data in sql server using classic aspin ASP ClassicHow to insert excel file data in sql server using classic asp
I have excel file i want to insert it into sql using asp and not using sql server -
how to backup of table from database in sql server 2005 express edition
i have table in sql server 2005 express edition i wanna transfer that data from one server to another server can u pls help me..... -
How to run sql select statement in sql job (sql 2000)
i want to create sql job that runs a simple select query at specific time -
i have one form.asp page it inserts data in database
in database i have table freetrial and freetrial_backu p
freetrial table has startdate and enddate column (startdate = whn users submits form ) and enddate is plus 2 days of startdate
when enddate is not equal to currentdate it should MOVE the record to freetrial_backu p table i think so it can be done by SQL JOB but i have not extact code 4 it pls help me..... -
thanks 4 reply but it doesnt work i m explaining u what i need:-
table has three column (name, registrationdat e, enddate)
when some one fills form data is inserted in table freetrial
registrationdat e is currentdate when user submits the form and enddate is plus 2days of registrationdat e)
when enddate is over it should MOVE that record to freetrial_backu p table pls help me....Leave a comment:
-
thanks for answer but i have mention when enddate is over than only it should transfer the data (if i run above query it transfer all the data from one table to another table table??? enddate is after 2 days of registrationdat e of user)Leave a comment:
-
http://www.aspdevelope.com/
with this url u can download classic asp editor and create datagrid view and help file is also there......Leave a comment:
-
how to move one table data to another table in sql server
I have 2 table in sql server freetrial and freetrial_backu p, freetrial table contain startdate and enddate when enddate is over it should transfer all data to freetrial_backu p table pls help me(startdate is registrationdat e and enddate is 2days after registrationdat e)
No activity results to display
Leave a comment: