hi, i have to retrieve data from two tables in an oracle database over odbc. is there a step-by-step guide about how to connect to that oracle via...
Hi all, I have almost finished my first replication tests, with publisher and subscriber on the same sql server. Now I wanted to add a...
i'm struggling with merge replication and foreign key constraints. i have four tables: - owners(id, name, firstname, address, phone) - cars(id,...
hi<br /><br />in oracle i can have a field number(<img src='/community/emoticons/emotion-11.gif' alt='8)' />, which indicates that the number can be...
hi all, i need to have named constraints in my create table scripts. therefore, i need to do the following: CREATE TABLE users ( id int...
hi, i know from years ago that i had the same problem when i was working with sql server. when i try to do an "insert into"...."values", and after...
hi What is the best method to port my database from postgreSQL to Ms SQL Server 2005? I have a dozen of sql scripts to create and configure all...
i have two sql files. - one with create table statements - one with fill table statements. when i execute the first .sql file, is there a statement...
Requirements say that we have to use active directory with single sign on. Now, I don't know much about this, but they installed an sql server 2005...
I've worked for some time with Oracle. To script our tables (creation, default data,...) we had serveral sql files (one for each creation and filling...
hi all, I've been studying a few days replication because we have to implement it in near future. At first sight, merge replication will suit us...
Separate names with a comma.