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

What is 1nf 2nf and 3nf?

960

---

How to convert character strings into numeric values?

1151

---

How to set database to be single_user in ms sql server?

1082

---

What are indexers?

1134

---

Can a table have 2 foreign keys?

958

---

what is normalization? : Sql server database administration

1162

---

Is it possible in sql table to have more than one foreign key?

1094

---

What do you understand by physical_only option in dbcc checkdb?

1026

---

What are the general features of sql server management studio? : sql server management studio

1136

---

What is the maximum number of index per table?

1120

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1117

---

What is the sql profiler?

1001

---

Can two tables share the same primary key?

987

---

What are the tools available in market as an alternative to sql server reporting services?

138

---

Explain indexed views and partitioned view with their syntax.

1195

---