Answer / rainy

yes::
it is used to update particular info.

Answer / radhakrishnan vaithilingam

Yes.
The SET is keyword in SQL Server. The SET is ANSI standard.

Answer / digvijay

yes, set is assign the value in declared variable.

exaple:--

declare @a int
set @a=20
@a hold the 20.

Answer / 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';

Define inner join? Explain with an example?

0 Answers  

---

Explain the properties of sub-query in sql server?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

What is indexed views? plz explain with example?

2 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

Explain the stored procedure?

0 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---