Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

How to execute a stored procedure in ms sql server?

0 Answers  

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

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  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

Explain contrast amongst grouped and non-bunched records?

0 Answers  

---