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 overcome kernel isssues
What is optimization and its types?
How to download and install the scaled-down database adventureworkslt?
What is the difference between dropping a database and taking a database offline?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I connect to sql server database?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is SQL Azure Federations?
How you can get a list of all the table constraints in a database?
What are the transaction properties?
What is the difference between TRUNCATE and DROP?
Explain transaction server isolation?
How to encrypt data between dialogs?
what's the maximum size of a row? : Sql server database administration
How to connect to SQL Azure Database by using sqlcmd?