Answer / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Answer / sivasiva

Triggers:
Triggers create event that event pass the value for
insert,update delete automatically updated value for the
table.triggers are event driven sepecified procedure.store
and managed by DBMS.automatically fires the value.

Store procedure:
Fast Accesing.Reduse network traffic.sepatre businees rules
and logic from presentation layer

Name the different type of indexes in sql?

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  

---

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

---

query processing

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---