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

Mention the different types of replication in sql server.

0 Answers  

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

What is a stored procedure?

3 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

What are triggers in ms sql server?

0 Answers  

---

How to tune a stored procedure?

6 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

What is data modeling and Reterminal integrity?

0 Answers  

---