Answer Posted / ashish jain

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp where count(empname)>1

Can you pass expressions to stored procedure parameters?

970

---

What is a unique key constraint?

971

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

888

---

If a table does not have a unique index, can a cursor be opened on it?

872

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

184

---

Can sub report data source be different from that of the parent report?

135

---

How to connect php with different port numbers?

1002

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

953

---

What are the new features are introduced in sql server 2012 reporting services?

143

---

How do I view a stored procedure in sql server?

944

---

What is dynamic cursor in SQL SERVER?

1001

---

How to connect to a sql server using odbc_connect()?

1094

---

What is normalization and denormalization in sql server?

948

---

Should you normalize audio?

879

---

What do you mean by tablesample?

1031

---