#眉標=VS2010 Ultimate、SQL Server、T-SQL #副標=Visual Studio 2010資料庫建構(2) #大標= SQL Server 2008物件的開發 #作者=文/圖 胡百敬 =====程式1 =========== CREATE TABLE tblTest ( PK int IDENTITY(1,1) PRIMARY KEY, CustomerID NCHAR(5) FOREIGN KEY REFERENCES Customers(CustomerID), BeginDate DATETIME NOT NULL, DueDate DATETIME NOT NULL, CONSTRAINT chkDueDate CHECK(DueDate >= BeginDate) ) ================== ===<反灰>============= CREATE TABLE [dbo].[tblTest] ( [PK] [int] NOT NULL IDENTITY(1, 1), [CustomerID] [nchar] (5), [BeginDate] [datetime] NOT NULL, [DueDate] [datetime] NOT NULL ) ================ ===<反灰>============= ---主鍵定義 ALTER TABLE [dbo].[tblTest] ADD CONSTRAINT [PK_tblTest_PK] PRIMARY KEY CLUSTERED ([PK]) ---外鍵定義 ALTER TABLE [dbo].[tblTest] ADD CONSTRAINT [FK_tblTest_Custome_CustomerID] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers]([CustomerID]) ================== =====<反灰>============= ALTER TABLE [dbo].[tblTest] ADD CONSTRAINT [chkDueDate] CHECK (([DueDate]>=[BeginDate])) ================== =====<反灰>============= CREATE VIEW [dbo].[vwCustomers] AS SELECT * FROM myNorthwind.dbo.Customers; ================== =====<反灰>============= CREATE VIEW [dbo].[vwCustomers] AS SELECT * FROM [$(DB)].dbo.Customers; ================== =====程式2 <反灰>============= IF Exists(SELECT * FROM fn_listextendedproperty( 'Developer', null, null, null, null, null, null )) BEGIN EXEC [dbo].sp_dropextendedproperty 'Developer' END EXEC [dbo].sp_addextendedproperty 'Developer', '$(Developer)' IF Exists(SELECT * FROM fn_listextendedproperty( 'Version', null, null, null, null, null, null )) BEGIN EXEC [dbo].sp_dropextendedproperty 'Version' END EXEC [dbo].sp_addextendedproperty 'Version', '$(Version)' =================== ===<反灰>============= CREATE VIEW [dbo].[vwCustomers] AS  SELECT * FROM Customers c ================ ===<反灰>============= CREATE VIEW [dbo].[vwCustomers] AS SELECT [c].[CustomerID], [c].[CompanyName], [c].[ContactName], [c].[ContactTitle], [c].[Address], [c].[City], [c].[Region], [c].[PostalCode], [c].[Country], [c].[Phone], [c].[Fax] FROM [dbo].[Customers] c ================