Why is replication required on the sql server?

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

What are types of subqueries?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

What is the New in SQL server 2008?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What are group functions in query statements in ms sql server?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---