Why are sql functions used?

0 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

Can you force a query to use a specific index?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

How do SQL server 2000 and XML linked?

2 Answers  

---

How to assign new column names in a view?

0 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

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 would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What are the properties and different types of sub-queries?

0 Answers  

---

How does stuff differ from the replace function?

0 Answers  

---