Is SET a SQL Keyword?

Answers were Sorted based on User's Feedback

Is SET a SQL Keyword?..

Answer / rainy

it is used to update particular info.

Is This Answer Correct ?    44 Yes 1 No

Is SET a SQL Keyword?..

Answer / radhakrishnan vaithilingam

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

Is This Answer Correct ?    13 Yes 4 No

Is SET a SQL Keyword?..

Answer / digvijay

yes, set is assign the value in declared variable.


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

Is This Answer Correct ?    7 Yes 3 No

Is SET a SQL Keyword?..

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

What is the default fill factor value?

0 Answers  

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

what is the output for this query select * from employee where 1=1;

4 Answers  

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

what is call by value & call by reference ?

2 Answers   Cap Gemini,

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

Explain Normalization and DE normalization

0 Answers   iNautix,

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to

6 Answers  

how to get the automatic backup of the database in the sql server

4 Answers  

How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,