Answer Posted / ravi148

hi,

dileep is exactly correct , arun .. iam sorry to say ur
wrong

suppose for employee table, write as
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from EMPLOYEE
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp

What is database replication?

1130

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1899

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

969

---

What do we have to check in database testing?

1012

---

What are the 3 types of schema?

1103

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1095

---

How to choose all records from the table?

1059

---

What is the sql profiler?

933

---

How is a full-text index updated?

947

---

Explain full-text query in sql server?

992

---

What is the difference between a primary key and a unique key? Are they the same?

1072

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1099

---

What is Replication?

1039

---

What gets stored inside msdb database?

1242

---

how many clustered indexes can be created on a table? : Sql server database administration

1140

---