Answer Posted / 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 This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can you implement data mining in SSRS?
What are the purpose of Normalisation?
What is the difference between char and varchar2 datatype in sql?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to fine-tune reports?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain about Views?
What are distributed partitioned views?
what is the difference between Tabular and Matrix report?
Explain few examples of stored procedure over triggers?
List types of tables in SQL Azure?
List out different types of normalizations in sql server and explain each of them?
What are the different types of collation sensitivity?
Why use view instead of a table?
How do I setup a local sql server database?