Answer Posted / kumar.t

Name : New

Sno Name
1 Rajesh
2 Rajesh
3 Raja
4 Raja
5 Arun
6 Bala

Delete From New Where Sno Not IN
(Select Min(Sno) From New Group By Name)

What are constraints?

960

---

When does a workload on SQL Azure get throttled?

129

---

Can another user execute your local temporary stored procedures?

942

---

Explain what are the database objects? : SQL Server Architecture

1006

---

What is the bookmark lookup and rid lookup?

943

---

What is report snapshot?

142

---

How do I create a stored procedure in sql server?

965

---

Do you know what is user defined datatypes and when you should go for them?

909

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

938

---

What happens when converting big values to numeric data types?

1032

---

What are secondary xml indexes?

987

---

How do I view a script in sql server?

980

---

What is the default order of an order by clause?

946

---

How to find index size for each index on table?

963

---