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 |
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
what is a traditional network library for sql servers? : Sql server database administration
Can you explain different types of joins?
What are the different ways of moving data/databases between servers and databases in SQL Server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to delete the duplicate rows from a table in SQL Server ??
Why I have to use stored procedures?
What is the difference Between Sql-server 2000 & 2005
What is Query Execution Plan? How does it help optimize or tune a database driven application?
What do you do in data exploration
How to read data in a table with "select" statements?
What are the extra roles available in msdb? : sql server security
Oracle (3253)
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)