Answer Posted / nikhila reddy

6. select top,ditinct,aggregations
steps to execute a query

1. from table1 joins table2
2. on condition
3. where condition
4. group by condition
5. having condition
7. orderby

these way we write the query,
while executing a query internally itwill puul data from table 1 and placed in temp1 as same table2 into temp2
result in temp3.then it checks where conditon and place in temp4 so on.........

What is a database in ms sql server?

1101

---

What is model database in sql server?

1098

---

Define Unique Key?

1062

---

What are the advantages of stored procedure in sql server?

927

---

What extended events?

1059

---

How do I create an extended event in sql server?

999

---

What are the differences between DDL, DML and DCL in SQL?

1277

---

How to resolve the orphan use problem? : sql server security

1066

---

Can we write ddl in trigger?

964

---

Give me any three differences between Truncate and Delete.

1153

---

Difference between group by clause and having clause in SQL?

1019

---

what is normalization? : Sql server database administration

1155

---

Please differentiate between a local and a global temporary table?

1055

---

What is SubQuery in SQL Server 2008

1067

---

Define ACID properties in a Database?

1099

---