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

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...

7 Answers   Value Labs,

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Can you explain different types of joins?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What do you do in data exploration

0 Answers   EXL,

---

How to read data in a table with "select" statements?

0 Answers  

---

What are the extra roles available in msdb? : sql server security

0 Answers  

---