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

What are the advantages of using stored procedures in sql server?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What are the advantages of stored procedure in sql server?

0 Answers  

---

What is tcl in sql server?

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Which are the third-party tools used in sql server and why would you use them?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

What is difference between equi join and inner join?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

Do you know what are acid properties?

0 Answers  

---