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

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

---

What is the importance of a recovery model?

0 Answers  

---

---

What is difference between order by and group by?

0 Answers  

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---