473,567 Members | 2,897 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to write a trigger after insert

1 New Member
hi,,,,
i am having three tables(i.e,)emp loyee,departmen t,EDo tables and from that department no is common in all the three tables and when inserting the status should be set for that i have to write the stored procedure and trigger after insert and in sp we have to write update status and select statements.in select statement we have to pass the get the department name from table EDo where dept no is given.(i.e,)fro m the sp and trigger after insert when i give the department number then it should bring the department name out from the table.......
Jun 9 '11 #1
1 1568
ck9663
2,878 Recognized Expert Specialist
Post what you have so far, and we'll see what we can do to help.


~~ CK
Jun 9 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3544
by: Sean | last post by:
Hey all, I'm new to triggers and I don't know if what I want is possible. I have a parent table, dbobjects say. And I have a persons table. bdobjects.id is a primary key persons.id is a primary key and references dbobjecs.id. Descriptively what I want is:
8
8590
by: Jason | last post by:
I have a table that matches up Securities and Exchanges. Individual securities can belong on multiple exchanges. One of the columns, named PrimaryExchangeFlag, indicates if a particular exchange is the primary exchange for that symbol. Each symbol can only have one primary exchange. I am trying to write a insert/update/delete trigger that...
6
6537
by: Scott CM | last post by:
I have a multi-part question regarding trigger performance. First of all, is there performance gain from issuing the following within a trigger: SELECT PrimaryKeyColumn FROM INSERTED opposed to: SELECT * FROM INSERTED
1
1460
by: ajay.sonawane | last post by:
Hello Experts I am new in Sql triggers and i would like some help I have a Table called ITEM and another callded SOURCE ItemNo,ItemName,SourceNo SourceNo,Source i want to create a Trigger so when i delete a record from all
3
2954
by: Ryan Liu | last post by:
Hi, What does ArrayList.Synchronized really do for an ArrayList? Is that equal to add lock(this) for all its public methods and properties? Not just for Add()/Insert()/Remvoe()/Count, but also for Item (this)? Normally,do I need sync at all? Isn't that true without sync the program can run faster?
1
2473
by: Dragon | last post by:
I am using mysql with the InnoDB engine. I wrote a perl script that first selects something from a table, and then updates a second table based on the select from the first table. I need to make sure that there is no read or write to the tables while my script performs the insert and update. I looked at...
1
1235
vikassethia
by: vikassethia | last post by:
I am using OleDb Connection in VB .NET, and i want to insert data in two different tables of database on single butten click event, so plz send me appropiate insert Query for this........... Thanking you
1
1243
by: suvarna10 | last post by:
plz help me, I have two databases,I have to write trigger on one database in such a way that,data entered in one database should be visible in another database.
1
6329
by: Swan | last post by:
Plz tell me how to write trigger in sql server 2005.Is there any special syntax for it?It's different from sql server 2000.Thanking you!
0
7688
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7905
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8115
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7651
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5488
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5216
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3630
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2093
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
930
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.