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

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

Explain syntax for disabling triggers?

0 Answers  

---

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What is the stuff?

0 Answers  

---

What are views used for?

0 Answers  

---

What is exporting utility?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

whats the maximum size of view state??

0 Answers  

---