Answer Posted / sivasiva

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1

How to create an inline table-valued function?

979

---

How does normalization work?

923

---

What is system stored procedures?

1040

---

What are the differences between web role and worker role?

122

---

What are sub reports and how to create them?

139

---

What are the functions in sql server?

947

---

What are the dmvs?

1014

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

971

---

Is sql server free?

920

---

What is pessimistic concurrency?

976

---

What is global temp table?

995

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1141

---

What is the difference between upgrade and migration in sql server?

1090

---

What happens if strings are casted into wrong code pages in ms sql server?

1113

---

Which are new data types introduced in sql server 2008?

1049

---