Stefan wrote:
> --- cut ---
> CREATE TABLE [tblObjects] (
> [O_ID] uniqueidentifier ROWGUIDCOL NOT NULL ,
> [Number] [varchar] (36) NOT NULL ,
> [Active] [bit] NOT NULL ,
> [Title] [nvarchar] (100) NOT NULL,
> [Description] [nvarchar] (150) NULL ,
> [Comment] [ntext] COLLATE NULL ,
> [_c_date] [datetime] NOT NULL ,
> [_e_date] [datetime] NOT NULL ,
> [OID] [int] IDENTITY (1, 1) NOT NULL ,
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> --- cut ---
>
> Tja, aber wie �bergebe ich da Default-Werte?
Ganz einfach
ALTER TABLE [dbo].[tblObjects] WITH NOCHECK ADD
CONSTRAINT [DF_tblObjects_Description] DEFAULT ('defaultwert') FOR
[Description]
gruss
frank
www.xax.de
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp
