Thx for the update,
My first database(Table1) is in the QA server and the Second one (Table2)in the Development Server.I want to pull teh records from QA to development so that we can rerun that once ina month.
Can u Pls explain abt the DTS package u have mentioned..Will that solve this prob? I...
I have the records in a database( Table 1) .Now I want to write code, to pull those data from Table1 to different database(Table 2) which is on a different Server and should run that (Table2) code every month.ie.it has to be rerun.
Can anyone of u Pls help me with this code. I use Microsoft Sql...
Hi all---
We are working with Microsoft SQL Server and when we try to insert a record into a table
called 'employee salary', we get the following errormessage:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY...
Software Used: VB 6
Database: SQL Server
PROBLEM DESC:
I have the following code as an example: (This code needs to work in a generic scenario also, I have just taken some example here like "Employeeid =123", but in general any Employeeid should work and cannot be hard coded)
If szSenderID =...
VB 6 Code:
If szSenderID = "sss" And dict_L11.Item("employeeIdQualifier") = "zz" And IsNumeric(Left(dict_L11.Item("employeeId"), 1)) = True Then
dict_L11.Item("employeeId") = "AB" & dict_L11.Item("employeeId")
The result for this Code is
IF Employeeid= 123 it gives result as "AB123"
if...
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.