Fermé

need simple SQL statement to copy table in classic asp

Simple SQL Statement needed for Classic ASP routine

There are two nearly identical databases

DBOrig and DBCopy

Both databases (which happen to be on different IP addresses but within the same network) contain the same table definition/structure for the table TEST

I need a simple SQL statement or two that will copy all the records from [login to view URL] to DBCOPY.test. Ideally, it should be an ‘append’ or ‘insert’ Snippet of subroutine is below. It is NOT an option to list all the field names (over 100 fieldnames)

‘===================================================================

sub CopyData(TableName)

dim rsCopy, objCopy, SQLCopy, Connect1

dim rsOrig, objOrig, SQLOrig, Connect2

' Routine copies the entire table from rsOrig to rsCopy

Connect1="UID=********;PWD=*********;Driver={ODBC Driver 17 for SQL Server};Server=192.168.101.x\SQLExpress;Database=SF-Master;"

Connect2="UID=********;PWD=*********;Driver={ODBC Driver 17 for SQL Server};Server=192.168.101.y\SQLExpress;Database=SF-Master;"

set objOrig = [login to view URL]("[login to view URL]")

[login to view URL] Connect2

set RsOrig = [login to view URL]("[login to view URL]")

SQLOrig = "Select * from Test"

[login to view URL] SQLCopy, objCopy, adOpenForwardOnly, adLockOptimistic

set objCopy = [login to view URL]("[login to view URL]")

[login to view URL] Connect1

set RsCopy = [login to view URL]("[login to view URL]")

?????? SQLCopy = "INSERT INTO (" & TableName & ") SELECT " & TableName & "." & FROM " & TableName * DELETE FROM " & table

[login to view URL] SQLCopy, objCopy, adOpenForwardOnly, adLockOptimistic

End sub

Compétences : SQL, ASP

en voir plus : sql injection prevention classic asp, classic asp sql server 2005, asp simple form sql, sql server 2005 stored procedure copy table, sql server russian characters classic asp, classic asp simple export csv, export script sql table using classic asp, sql bcp copy table sql 2000 sql 2005, sql 2005 copy table data view, show sql statement classic asp, sql server 2012 connect classic asp, classic asp search table sql, sql server copy table from one database to another different server, sql azure copy table from one database to another, sql server copy table from one database to another with identity, sql server copy table from one database to another different server using query, sql server copy table with data

Concernant l'employeur :
( 7 commentaires ) Farmington, United States

Nº du projet : #28425259

10 freelances font une offre moyenne de 28 $ pour ce travail

ITservice

Hi I have 15+ years of experience. I will write the script to copy the data from one table to another in different server. Look forward to hear from you. Regards

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(237 Commentaires)
7.7
nurba

Hi, I am interested to your project, since I have great experience in classic asp with more than 15 years experience. Your requirement is clear, but classic asp is limited doing some queries. can be done with loopin Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(85 Commentaires)
5.8
kietlt10988

Hi there, I have go through your job description. I am really excited with this job. I am an experience T-SQL developer with more than 9 years experience. I am able to done any kind of project using this skill. I hav Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
5.5
SqlDevelopment

I can develop required SQL query in a most qualitative way because I am highly qualified SQL developer with a long term professional experience.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
4.4
faisalazeem20

Hello, good day. I reviewed your requirements and ready write sql query which will copy data from one table to another. I have 5 years of experience in database development. Let's discuss in details Thanks Faisal

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
1.8
deeptimayipadhi

Hi There, *** I have gone through the requirement and can complete the project efficiently *** Check below link on my profile for reviews and portfolio items; https://www.freelancer.com/u/deeptimayipadhi I have 9 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.4
vw2091242vw

Hello I have lopot of experience in classic Asp. And this can done in asp and sp. I'm interested in this task. Hoping to hear from you soon. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
1.0
apurv4585

Having 7+ year working experience in Software Development.I always provide quality solutions to complex business problems within scope, budget and tight schedules. Possess excellent knowledge of Web Applications . Deve Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
AZNTech202

Hi there, I am interested to do this task as it matches my skills. You'll get quality work in affordable price. Just send the message to discuss details. Have great day.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
MohammedAhsan

Hi, I am Mohammed Ahsan. I have 4+ years of experience in C#, ASP.NET, MVC, VBSCRIPT and VB6 I have worked for Hospital and Laboratory management system. I am best fit for your task. I will provide you quality work as Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.0