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
How to start and end transact-sql statements?
What is merge replication?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are the different types of replication you can set up in sql server?
What is a primary key?
How to access the inserted record of an event?
What are the steps you can take to avoid “deadlocks”?
Does sql server 2016 have ssms?
How to write a query with a left outer join in ms sql server?
Tell me about normalization in DBMS.
What are a database and a data warehouse?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is difference between materialized view and view?
What is the meaning of sql server?
What are the components of dbms?