Answer / 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.........

How do we rollback the table data in SQL Server

3 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

Can sql servers linked to other servers like oracle?

0 Answers  

---

Can another user execute your local temporary stored procedures?

0 Answers  

---

what is sql server? : Sql server database administration

0 Answers  

---

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---

What is a primary key?

0 Answers  

---

Explain full-text indexing?

0 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

How do you know which index a table is using?

4 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---