Answer Posted / raghuvir

Select *from Emp_table where salary=20000

will display all the employees who have salary 20000

What is change data capture (cdc) in sql server 2008?

558

---

How do you create a clustered index?

517

---

What is in place upgrade in sql server?

511

---

What are rows and columns?

509

---

What is surrogate key? : sql server analysis services, ssas

683

---

---

What is fill factor and pad index?

531

---

Can you use order by when defining a view?

567

---

How do you know if sql server is running on your local system?

530

---

How to create dbo table in sql server?

504

---

What is a domain constraint give an example?

555

---

What the different topologies in which replication can be configured?

552

---

What is temporary stored procedure?

542

---

What are the properties of the transaction?

533

---

What can be used instead of trigger?

615

---

Where are sql server usernames and passwords stored in the sql server?

605

---