ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is the importence of the trigger in sqlserver2000?
 Question Submitted By :: Sharifuddin
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the importence of the trigger in sqlserver2000?
Answer
# 1
hi all
     
     Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
 <statments>
end
 
Is This Answer Correct ?    1 Yes 1 No
Kinthada Cnu
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the types of indexes available with SQL Server?  2
Explain the new features of SQL server 2000?  1
What is the system function to get the current user's user id? TCS3
What is transaction ? Give me one example. Melstar7
What are the four main query statements?  3
Can you link only other SQL Servers or any database servers such as Oracle?  1
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?  2
What is Peer to peer Replication? HCL1
Difference between Cluster and Non-cluster index? Oracle9
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C vsworx7
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
Why we need a group by clause?  3
any one can explain Self mapping Delegation Remote Credentials  1
what is curser.  8
what are the joins,primary key,foriegn key, candidate key, super key and expain them? Polaris2
Can we use Truncate command on a table which is referenced by FOREIGN KEY?  2
How to write a script for upate the data in prod , i have 50000 row are there TCS2
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju  3
What is Covering Indexes? Plz explain with example  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com