Answer Posted / bhagya

select * from emp as e1 where 1= (select count(*)from emp
as e2 where e1.sal<e2.sal)

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1034

---

Tell me the phases a transaction has to undergo?

963

---

how would you store your query in an SSRS report or a Database server?

162

---

How do you start single user mode in clustered installations?

942

---

How to modify the underlying query of an existing view?

991

---

What is ems sql management studio? : sql server management studio

1112

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2348

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

972

---

What is Replication?

1052

---

What is a collation?

1093

---

Explain the etl (extraction, transformation, and loading)?

996

---

What is a natural primary key?

1051

---

What is faster join or union?

1213

---

How to include date and time values in sql statements?

1086

---

Explain triggers?

1009

---