Answer / Hemant Sharma

"The following are some of the restrictions applicable while creating views in Microsoft SQL Server:
1. Views cannot be used to modify data.
2. A view that includes an aggregate function can contain only one aggregate function and must group the data using GROUP BY clause.
3. The SELECT statement within a view cannot include ORDER BY, TOP, OFFSET, or FETCH NEXT statements.
4. The SELECT statement within a view cannot contain UNION, EXCEPT, INTERSECT, OUTER APPLY, CROSS APPLY, OPENXML, OPENQUERY, or TABLE (of a user table) as the source of data."

What is the difference between sdf and mdf?

1 Answers  

---

Can you explain full-text query in sql server?

1 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

Do you know what are the steps to process a single select statement?

1 Answers  

---

Can I delete event logs?

1 Answers  

---

What is a join in sql?

1 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

1 Answers  

---

Explain following error properties?

1 Answers  

---

Differentiate between sql temp table vs table variable?

1 Answers  

---

What are alternate keys?

1 Answers  

---

Where are full-text indexes stored?

1 Answers  

---