|
Hi, I have a bunch of sql scripts that create / drop sequences, users and other objects. I'm running these scripts through liquibase, but they fail because oracle complains when I try to drop a non existing sequence, or create an existing user.
Is there...
Started by Tom on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The downside.
exist/don't exist they will still be marked as ran and the update will continue.
|
|
I'm resurrecting a rather old code project, from when I was using CVS regularly, as a component in a new project that I've already been working on using git. I still have access to the CVS archive the old project's module is in, so I was just going to...
Started by UltraNurd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Fetch the repo into the existing repo and do a subtree merge in the existing git repository
Starting from the directory containing newproj, the existing git.
Reference that repo as a submodule.
|
|
OK so I suck at SQL and I always have to ask for help, not sure what my disconnect is because I don't have any problem with programming C like languages, here is my challenge:
I have a table full of tracking data for as specific course, course number ...
Started by Ryan on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Use SELECT to Insert records
INSERT tracking (userID, courseID, course, bookmark, course_date, posttest, post_attempts, post_score, post_date, complete, complete_date, exempted, exempted_date, exempted_reason, emailSent) SELECT userID, 11, course, bookmark... .
|
Ask your Facebook Friends
|
Hi All,
I have an eclipse project on my hard disk, which is a fairly recent check out from an SVN repository. I've imported this project into my Eclipse workspace, and now want to associate it with the SVN repository.
How do I do this? The only options...
Started by Richard on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Subclipse will notice the presence of .svn directories, ask you to confirm that the information is correct, and associate the project with subclipse .
Select SVN from the list, then click "Next".
Team->Share project is exactly what you need to do.
|
|
Answer Snippets (Read the full thread at superuser):
If you want to clone an existing HD into a virtual HD.
Is one of the options that shows when you create the virtual machine .
Just set up the VmWare guestto use and HD with an existing drive.
|
|
How to get existing control's controltemplate in WPF in XAML format(visual tree)? This is to help to create new controltemplate with the help of existing template.
Started by Sugirthini on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
However you can also extend existing style without redefining evrything by using.
Controls in there.
|
|
How to add a form field to an existing pdf with itextsharp?
I have an existing pdf document, I'd like to add form fields to it without creating a copy and writing out a new document.
Started by Tori Marrama on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at stackoverflow):
Public void AddFormFieldToExistingPDF( ....
(I guess this does make a copy but it's much cleaner than using the itext PdfCopy classes) .
I struggled with this for awhile so figured I'd post the Question & Answer
Using the PdfStamper itext class is the key .
|
|
Hello,
How do i partition existing table in SQL Server 2005/08 ? I couldn't find a better clue on it.
Started by Aneef on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
DROP INDEX MyTable_IXC ON MyTable WITH (Move To [Data Partition Scheme] (ID) )
Since you give no errors I suppose you... .
(Create table, insert data, then partition)
Trick is to move the table to the new partition .
Here is a full article on how to do this .
|
|
How to Set a existing column of MS SQL table as NOT NULL?
Started by Vinodtiru on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You might also want to add a default contraint to the column. .
ALTER TABLE tablename ALTER COLUMN columnname datatype NOT NULL
You will obviously have to make sure that the column does not contain any NULL values before doing this .
|
|
How do you add a column, with a default value, to an existing table in SQL Server 2000/2005?
Started by Mathias on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
ALTER TABLE Protocols ADD ProtocolTypeID int NOT NULL ....
And markdown ate my brackets.
ALTER TABLE ADD ColumnName Options
Here is a link that has all of the alter table syntax: http://doc.ddart.net/mssql/sql70/aa-az_5.htm
EDIT: Accidentally hit submit .
|