Answer Posted / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

Explain sql server service broker?

943

---

Can you create a logon trigger in sql server 2005 express edition?

1049

---

What is the importance of concurrency control?

1193

---

Can we update data in a view?

992

---

explain different types of constraints? : Sql server database administration

933

---

What is set nocount on?

908

---

Why are sql functions used?

1077

---

What is 2nf normalization?

982

---

How are the unique and primary key constraints different?

1030

---

How to define and use table alias names in ms sql server?

1080

---

Explain aggregate functions?

1043

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5887

---

How to create prepared statements using odbc_prepare()?

1020

---

Are all views updatable ?

1122

---

Can you roll back the ddl statement in a trigger?

928

---