postdeployscript.sql

< SQL Server2005程序设计>

CREATE TRIGGER trgUpdateContact
ON Person.Contact
FOR UPDATE
AS EXTERNAL NAME Chapter03.Triggers.trgUpdateContact
go
CREATE TABLE tblPoint(
	ID NUMERIC(18, 0) IDENTITY(1,1) NOT NULL,
	ThePoint dbo.typPoint NOT NULL

)
GO
INSERT INTO tblPoint VALUES ('1:2')
INSERT INTO tblPoint VALUES ('4:2')
INSERT INTO tblPoint VALUES ('5:3')
INSERT INTO tblPoint VALUES ('1080:512')