|
IF EXISTS (SELECT name FROM sysobjects WHERE name = N'tr_Framework_ApplicationParameters_InsUpd' AND type = 'TR')
DROP TRIGGER dbo.tr_Framework_ApplicationParameters_InsUpd
GO
/*
Purpose: 1. Create Balance Record
*/
CREATE TRIGGER dbo.tr_Framework_ApplicationParameters_InsUpd
ON Framework_ApplicationParameters
AFTER INSERT, UPDATE
AS
BEGIN
select cast(ins.Value as int)
from inserted ins
where ins.Type = 'INT'
IF (@@ERROR <> 0)
Raiserror('Operation is declined! Type of Value should be INT!', 16, 1)
END
Go
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.