Share on Google+Share on Google+

girish
sql server trigger example
2 Answer(s)      9 years ago
Posted in : SQL

Can any one tell me the live example of triggers in SQL Server?

Ads

View Answers

March 30, 2008 at 9:47 AM


if u click pistal trigger ,it auotmatically shoot bullet

it's like newtons 3rd law
(every action s having an equal reaction )


June 21, 2012 at 6:19 PM


CREATE TRIGGER trgAfterInsert ON dbo.Dit FOR INSERT AS declare @DID int Declare @SID int

select @DID =i.DID from inserted i; 
select @SID=i.SID from inserted i;

insert into NationalLevel135.dbo.Dit1(DID ,CenD,NameG,NameE,SID) values(@DID ,@DID ,'sn','eh',@SID);

PRINT 'UPDATE Trigger fired.'

GO










Related Tutorials/Questions & Answers:
using trigger - SQL
-update-trigger.shtml http://www.roseindia.net/sql/trigger/mysql-trigger-after...using trigger  sir i want to use this trigger in ado.net. how it is possible ? Create trigger tr1 on student after update as begin update m
Create Delete Trigger in SQL
The Tutorial illustrate an example from 'Create Delete Trigger in SQL... Create Delete Trigger in SQL       Create Delete Trigger in SQL fire this trigger before
Advertisements
Sql Server - SQL
sql server trigger example  Can any one tell me the live example of triggers in SQL Server?   if u click pistal trigger ,it auotmatically shoot bullet it's like newtons 3rd law (every action s having an equal reaction
Create After Update Trigger in SQL
illustrate an example from 'Create After Update Trigger in SQL'. In order... Create After Update Trigger in SQL       After Trigger in SQL is fired before update
example of before insert trigger in mysql
example of before insert trigger in mysql  Hi, How to create a simple before insert trigger in MySQL? Thanks   Hi, The before insert trigger is executed before saving the data into database. Trigger is stored
Create Before Insert Trigger in SQL
Create Before Insert Trigger in SQL       The Create Before Insert Trigger in SQL fires the trigger... Tutorial describe you a code on 'Create Before Insert Trigger in SQL'. To grasp
How to trap Trigger Error - SQL
How to trap Trigger Error  Hi Guys, Can you please help with my problem?.. Is there a way in where I can trap all SQL error and place it under... NVARCHAR(2000) ) select * froM ERROR_LOG CREATE OR REPLACE TRIGGER
Create After Insert Trigger in SQL
from 'Create After Insert Trigger in SQL'. In this Example, we create... Create After Insert Trigger in SQL       Create a Trigger is a special kind of stored procedure
Create Before Update Trigger in SQL
Update Trigger in SQL' . To understand this example we create a table 'Stu... Create Before Update Trigger in SQL       Create Before Update Trigger in SQL is used in SQL
Create Before Update Trigger in SQL
'Create Before Update Trigger in SQL' . To understand this example we create... Create Before Update Trigger in SQL       Create Before Update Trigger in SQL is used
Create Before Insert Trigger in SQL
Create Before Insert Trigger in SQL       The Create Before Insert Trigger in SQL fires the trigger before we insert the value into the table. Understand with Example
Create After Update Trigger in SQL
illustrate an example from 'Create After Update Trigger in SQL'. In order... Create After Update Trigger in SQL       After Trigger in SQL is fired before update
Trigger
an example from 'Trigger After Delete' in Mysql. To understand... Trigger After Insert The Tutorial illustrate an example from Mysql... Trigger after Update The Tutorial understand an example from 'Mysql
Create Delete Trigger in SQL
The Tutorial illustrate an example from 'Create Delete Trigger in SQL... Create Delete Trigger in SQL       Create Delete Trigger in SQL fire this trigger before
Example of Cron Trigger
Example of Cron Trigger     ... Trigger example and by this, you can better understand the working of cron trigger... a Quartz application with the help of cron trigger. For this, we have to make
SQL Server
SQL Server  Hii, What is SQL Server ?   hello, SQL Server is a DBMS system provided by Microsoft
sql server - SQL
sql server  what is SQL server? & what is oracle? are they same
trigger
trigger  write a trigger to see every manager must be highest salary
trigger
trigger  write a trigger program before insert into salary that it must not below Rs 1000
trigger
trigger  write a trigger program before insert into salary that it must not below Rs 1000
sql server - SQL
sql server  How many no of tables can be joined in same sql server
Create After Insert Trigger in SQL
a example from 'Create After Insert Trigger in SQL'. In this Example, we...Create After Insert Trigger in SQL       Create a Trigger is a special kind of stored
MySQL After Trigger
MySQL After Trigger This example illustrates how to create the trigger and what is the use it. In this example we create a table "Roseindia"...' and 'description'. A trigger is defined to activate when an INSERT, DELETE, or UPDATE
XML in SQL Server
XML in SQL Server  Hi..... please anyone tell me about What is the purpose of FOR XML in SQL Server? Thanks
date problem in sql server - SQL
date problem in sql server  select count(*) from xxxx_tbl where emplid="+emplid+" and work_dt=#"+work_date+"#"; work_date is in string ,Backend is sql server 2000.i am getting the date problem when using in jsp page.  
SQL SERVER 2008
SQL SERVER 2008  when i am fill the all fields in the form.but when i am retrive from the database it shows only firstname,age,address.remaining fields was shows as null.and it shows the gender as the on.i can't understand what
Merge databases in SQL SErver 2005
Merge databases in SQL SErver 2005  Please help me to merge databases in SQL server 2005
What is Trigger?
What is Trigger?  What is Trigger?   Hi, A trigger... and DELETE. The difference between a trigger and a stored procedure is that a trigger is activated or called when an event happens in a database table, a stored
Sql Server 2008 with textbox
Sql Server 2008 with textbox  **Hi, I tried to insert into DB using textbox in a form using vb by visual studio 2010 but its always catch an error... myconn = New SqlConnection("server=localhost;" & "Initial Catalog=4
Java to SQL Server Connectivity
Java to SQL Server Connectivity  Hi, heres my code private void bookedButton() { try { Class.forName... with sql server connectivity at the background to save the data. Now, after
What is Trigger?
What is Trigger?  What is Trigger
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads