Answer Posted / divya mahendra sikarwar

Execute queries:

CREATE TABLE dbo.Test1 (
[ID] [int] ,
[FirstName] [varchar](25),
[LastName] [varchar](25)
) ON [PRIMARY]

INSERT INTO Test1 VALUES(1, ‘Bob’,'Smith’)
INSERT INTO Test1 VALUES(2, ‘Dave’,'Jones’)
INSERT INTO Test1 VALUES(3, ‘Karen’,'White’)
INSERT INTO Test1 VALUES(1, ‘Bob’,'Smith’)
INSERT INTO Test1 VALUES(4, ‘Bobby’,'Smita’)

select identity(int,1,1) as SlNo,* into #temp from Test1

DELETE
FROM #temp
WHERE SlNo NOT IN
(
SELECT MAX(SlNo)
FROM #temp
GROUP BY ID,FirstName,lastname
)

drop table test1

select * into test1 from #temp

alter table test1 drop column SlNo

select * from test1 order by id

Differentiate between mongodb vs. Sql server?

1081

---

What are the advantages dts has over bcp?

995

---

Explain atomicity?

1035

---

How to deploy the Report?

138

---

How to create a simple user defined function in ms sql server?

1006

---

What is self contained sub query?

1028

---

What is bcp? When does it used?

972

---

Why de-normalization required?

995

---

Explain about unique identifier data type in sql server?

903

---

What command would you use to create an index?

1048

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1028

---

What is tempdb database? : SQL Server Architecture

1178

---

How do database indexes work?

1004

---

Explain different types of locks in sql server.

1068

---

How to store and query spatial data?

982

---