Re: SQL2K Migration: Problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 17 Nov 2002 14:12:59 +0100
Message-ID: <ee5ftuovvnv9gnciva9f5s7dj9u38js7fq@4ax.com>

On Sun, 17 Nov 2002 11:49:43 -0000, "Frank Ashley" <frank.ashley_at_ntlworld.com> wrote:

>I've got to migrate a SQL2K DB to Oracle9i.
>
>With MS SQL I can create a default value then bind that value to a column.
>The idea being that if a value isn't supplied in an insert for that column
>then the default value will be applied.
>
>eg
>create default MAXDATE as '99991231 12:00:00'
>
>EXEC sp_bindefault 'DBO.MAXDATE', 'XXX_UNIT.UNT_EXPIRED'
>
>Can anybody help?
>
>

Please do not multipost.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Nov 17 2002 - 07:12:59 CST