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

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What are the types of joins in sql?

0 Answers  

---

What are the acid properties?

0 Answers  

---

Can we use where clause with group by?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

What is relationship? What number of sorts of relationship are there?

0 Answers  

---

How to make remote connection in database?

0 Answers  

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

What is the difference between varchar and nvarchar?

0 Answers  

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---