Answer Posted / karthick.r

the query to display a particular record for the emp'v4290'
is given below

select * from employee where empid="v4290";

in this eg employee is the table-name and v4290 is the value
for the attribute empid. where is the clause to fetch the
record from the backend database table

Can group functions be mixed with non-group selection fields in ms sql server?

924

---

What are alternate keys?

967

---

What is an index. What are the types?

1060

---

What are entities and relationships?

953

---

When does a workload on SQL Azure get throttled?

129

---

What are different replication agents and what's their purpose? : sql server replication

993

---

What is a with(nolock)?

967

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1071

---

What happens if null values are involved in boolean operations?

968

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

964

---

Explain transaction server implicit?

969

---

What is a trace frag?

1062

---

What is change data capture (cdc) feature?

1041

---

What is a functions and types in sql server?

1062

---

What are the lambda triggers?

886

---