Welcome T-SQL Statements ;-)
Posted
lunedì 19 marzo 2007 11.17
by
francesco
USE AdventureWorks
GO
CREATE TABLE [Person].[Child] (
[ChildID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[FirstName] [dbo].[Name] NOT
NULL,
[LastName] [dbo].[Name]
NOT NULL,
[BirthDate] [datetime] NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Child_rowguid] DEFAULT (newid()),
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Child_ModifiedDate]
DEFAULT (getdate()),
CONSTRAINT
[PK_Contact_ChildID] PRIMARY KEY CLUSTERED
(
[ChildID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [Person].[Child]
WITH CHECK ADD CONSTRAINT [CK_BirthDate] CHECK (([BirthDate]<=GetDate()))
GO
INSERT [Person].[Child] ( [FirstName], [LastName], [BirthDate] )
VALUES ('Ivan', 'Quaratino', '20070315')
GO
/*
Per la precisione si è trattato delle 16:40 di un giovedì diverso da tutti gli altri...
*/