i have the same hardware as you (40GB disk, 1GB Ram, 1800Mhz), but there's no way to run oracle on it. it's the first time i install oracle myself...
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 have more information.<br />I really hope you can help me further, because i'm already struggling several days on it.<br /><br />Like i told...
quote:Originally posted by MohammedU If you include tables that contain foreign keys, the referenced table should also be included in the...
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...
i know i can also do it in two separate statements, but that looks a bit silly. i need it in 1 statement
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...
hmmm... how then would you write this: insert into (id, name, company, nationality) values ('1', select shipname from ships where id = 4,...
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...
quote:You could use SQLCMD in the same fashion. for the master script file, i have to use a .bat file or am i wrong? (and in the bat file, for each...
@Adriaan: why to use several script files: Because we have hundreds of sql files (*), and one master sql file that calls them all. this approach was...
ha, i found it myself how to remove all spaces. startup cmd with the following options: c:sqlcmd -W but the reason for sqlcmd trailing each result...
and how can i make my output more "readable" in the cmd console. when i do this: sqlcmd -q "select names from TestSrc.dbo.Ships;" -o C:o.txt and i...
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...
yes, i found that already, but it seems this tool does not work. i see nothing after my querries. no results, and even no errormessages. C:>sqlcmd...
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...
Separate names with a comma.
