•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,600 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,697 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 2109 | Replies: 5
•
•
Join Date: Apr 2006
Posts: 62
Reputation: 
Rep Power: 3
Solved Threads: 0
Junior Poster in Training
HI,
I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing it says “more than one value has been returned….”. How can I prevent that? For example; if I am 5th row trigger only read that row instead of all rows. I can’t do that.
CREATE TRIGGER exam_note ON dbo.exam
FOR insert
AS
DECLARE @note decimal(10,2)
select @note = (SELECT e_score FROM exam)
IF ( @note >=0 and @note<=50 )
update exam set e_note='Half'
else IF( @note >=51 and @note<=100 )
update exam set e_note='Full'
Thanks,
I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing it says “more than one value has been returned….”. How can I prevent that? For example; if I am 5th row trigger only read that row instead of all rows. I can’t do that.
CREATE TRIGGER exam_note ON dbo.exam
FOR insert
AS
DECLARE @note decimal(10,2)
select @note = (SELECT e_score FROM exam)
IF ( @note >=0 and @note<=50 )
update exam set e_note='Half'
else IF( @note >=51 and @note<=100 )
update exam set e_note='Full'
Thanks,
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Threaded Mode- problem with trigger (MS SQL)
- SQL trigger based on a true/false field value (MS SQL)
- Computed column in view VS trigger on update (MS SQL)
- Hi - how do you trigger a macro to run when a cell is updated in Excel? (Windows Software)
- Trigger onChange manually (HTML and CSS)
Other Threads in the MS SQL Forum
- Previous Thread: SELECT query only of jobids with tagids from all catids
- Next Thread: ORDER BY - join column
