Advertisement

1 - 10 of 49 containing alltags:("pk") (0 seconds)
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...
Zones: MS SQL ServerDate Answered: 04/16/2004 Grade: B Views: 0
Hi, which query should I use to find PK fields of a given table? TIA David
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 ...
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...
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...
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...
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" ...
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...
Zones: MS Visual BasicDate Answered: 09/15/2005 Grade: A Views: 0
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...
Zones: MS SQL ServerDate Answered: 10/15/2005 Grade: C Views: 0
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...
Zones: SQL Syntax, OracleDate Answered: 12/18/2007 Grade: A Views: 0