I have six separate database servers that I am trying to find a way to replicate data to, from a master database server. They all reside on the same machine. How can I replicate, preferably transac...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20717580.html
Hi,
which query should I use to find PK fields of a given table?
TIA
David
http://www.experts-exchange.com/Database/Sybase/Q_21112170.html
Zones:
SybaseDate Answered: 08/31/2004 Grade: B Views: 0
We have a parent table with a primary key of varchar2(3200). It was suggested to change the pk from varchar2(3200) to using Oracles sequences. I believe the parent table is mostly static. My first ...
http://www.experts-exchange.com/Database/Oracle/Q_21497976.html
Zones:
OracleDate Answered: 07/21/2005 Grade: A Views: 0
hi
I would like to perform an insert into database where it counts the records based on certain criteria and inserts a number in a particular field.
table "list"
ssn (pk) | fall(pk) | course(p...
http://www.experts-exchange.com/Database/MySQL/Q_20679370.html
Zones:
MySQL ServerDate Answered: 07/15/2003 Grade: A Views: 0
hi,
im using this radio button so that when i click on this button i can get 3 values at same time
<form name="" action="somefile.html" method="post">
<input type="radio" name="ddir"
onCl...
http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_20702828.html
Zones:
JavaScriptDate Answered: 02/10/2004 Grade: A Views: 0
I have a table which contains a PK field consisting of 2 fields. I have a C++ program which accepts a comma dilimited file as an argument which will perfrom insert/update on this table.
The c...
http://www.experts-exchange.com/Database/Oracle/Q_20753090.html
Zones:
OracleDate Answered: 12/17/2003 Grade: A Views: 0
ok im working with vb6/sqlserver
i need to get the PK of a record as soon as i create it
curently I add data then requery on that data to get pk
SQLstr = "Select * from tblstuff"
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_21196115.html
Zones:
VB DBDate Answered: 02/15/2005 Grade: A Views: 0
Hi folks,
I have a question. How can I return the PK of a newly added row?
This is the snipett of coding that adds the row:
'make the connection etc
Dim c...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21559711.htm...
Hi,
If I create a PK with unique constraint will an index be generated for this?
I can see that when configuring the PK you have the option when selecting UNIQUE of making it a CONSTRAINT or IN...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21596141.html
Can you please help with the SQL for:
I have 2 tables and wish to create a 3rd link table. The 2 tables are as follows
Table 1 - house with a PK houseid, other columns do exist
Table 2 - fur...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23030137.html