Answer Posted / ganesh dhage

SET is Reserved word in the SQL Server.Basically SET keyword is used for updating the particular record in the database table with some conditions...If i need to change the name of Student from Student table then i can write query like this->
update Student set Stud_Name=Ganesh
where StudID=201 and Email='abcd@pune.com';

What do you do in data exploration

997

---

Explain various data region available in ssrs with their use?

936

---

How to use "begin ... End" statement structures in ms sql server?

1050

---

What is a transaction and why is it important?

1092

---

Difference between primary key and clustered index?

1013

---

Can an automatic recovery be initiated by a user?

1019

---

Can you explain what are commit and rollback in sql?

944

---

What command do we use to rename a db, a table and a column?

927

---

How to enable tcp/ip protocol on a sql server?

1165

---

What is for xml in sql server?

1082

---

What is command parameter in ssrs?

164

---

how to use DTS package in 2000,2005,2008 in sql server

1838

---

How you trouble shoot when any job fails

1937

---

What is sql stored procedure?

1099

---

What is the difference between the 2 operating modes of database mirroring?

1114

---