what is the importence of the trigger in sqlserver2000?
Answer / kinthada cnu
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 ? | 2 Yes | 1 No |
How can we check the sql server version?
How do you clear a log file?
Explain cursor as data base object?
What is clustered primary key?
What is bit data type? What's the information that can be stored inside a bit column?
What is function of ROLLUP ?
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement
List out different types of normalizations in sql server and explain each of them?
Does partitioning improve performance?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
what is the difference between group and having give an example with query and sample output
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)