Hi,
We have a database in SQL Server. We are using ASP pages to update some of the data. We have a trigger set that if the rent entered is greater than 1000 it will fire. How do I make it work in ASP?? Please reply ASAP!
Here is the code for my trigger:
CREATE TRIGGER TooMuchRent
on team07_PropertyForRent_tbl
For Insert
AS
DECLARE @propertyNo char(5)
Set @propertyNo = (Select propertyNo from INSERTED)
If (Select rent FROM INSERTED) >1000
BEGIN
PRINT 'Assign expereinced staff member to property number '+ @propertyNo + '.'
End
We have a database in SQL Server. We are using ASP pages to update some of the data. We have a trigger set that if the rent entered is greater than 1000 it will fire. How do I make it work in ASP?? Please reply ASAP!
Here is the code for my trigger:
CREATE TRIGGER TooMuchRent
on team07_PropertyForRent_tbl
For Insert
AS
DECLARE @propertyNo char(5)
Set @propertyNo = (Select propertyNo from INSERTED)
If (Select rent FROM INSERTED) >1000
BEGIN
PRINT 'Assign expereinced staff member to property number '+ @propertyNo + '.'
End