Answer / Dinesh Chandra Joshi

The BEGIN and END keywords are used to delimit blocks of Transact-SQL statements within stored procedures, triggers, and functions. For example: BEGIN SELECT * FROM table_name; END;

What is raid, and how it can influence database performance?

1 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1 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  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

1 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

How to create a view on an existing table in ms sql server?

1 Answers  

---

What is difference between inner join and join?

1 Answers  

---

When we should use @@error?

1 Answers  

---

Define left outer join in sql server joins?

1 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---