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
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain trigger classes i.e. Instead of and after trigger?
How to call a function from a stored procedure in SQL Server ?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How to delete existing triggers using "drop trigger"?
What are the results of running this script?
Can you explain powershell included in sql server 2008?
What is molap and its advantage? : sql server analysis services, ssas
Why functions are used in sql server?
What are the different types of Indexes available in SQL Server?
What is SQL Azure Federations?
What is resource db in sql server?
What is the difference between a function and a trigger?
Can sql servers linked to other servers like oracle?
What is repeatable read?