Answers were Sorted based on User's Feedback
Answer / rainy
it is used to update particular info.
|Is This Answer Correct ?||44 Yes||1 No|
Answer / radhakrishnan vaithilingam
The SET is keyword in SQL Server. The SET is ANSI standard.
|Is This Answer Correct ?||13 Yes||4 No|
Answer / digvijay
yes, set is assign the value in declared variable.
declare @a int
@a hold the 20.
|Is This Answer Correct ?||7 Yes||3 No|
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 Emailemail@example.com';
|Is This Answer Correct ?||1 Yes||0 No|
Can anybody explain me cold backup and hot backup?
What is the default fill factor value?
How do you implement session management in SQL Server mode?
what is the output for this query select * from employee where 1=1;
i need some interview questions on sql server developer plz any onee send some links.
what is call by value & call by reference ?
What are the difference between data length and length in SQL Server-2008?
Explain Normalization and DE normalization
Explain the concept of view and Types of views in SQL server?
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 firstname.lastname@example.org
how to get the automatic backup of the database in the sql server
How we create SQL Server 2005 Reporting Services ? Give me Sample