How To Update Data In Mssql

Hello Friend Today In This Blog I Will Show You How To Create Update Data In Mssql.The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement.

In most cases, when using Transact-SQL to modify data in a SQL Server database, you issue an UPDATE statement that changes specific values. You can issue an UPDATE statement against a table or updateable view, as long as the statement modifies data in only one base table at a time.

By using an UPDATE statement, you can modify data in individual rows, sets of rows, or all rows in a table. An UPDATE statement must always include a SET clause, which identifies the columns to be updated. In addition, the statement can include a WHERE clause, which determines what rows to modify, or a FROM clause, which identifies tables or views that provide values for the expressions defined in the SET clause.

In this article, I discuss how to use the UPDATE statement to modify data. I also provide examples that demonstrate how the various clauses work. I created the examples in the AdventureWorks2008 database on a local instance of SQL Server 2008. However, most of the examples will work in the original AdventureWorks database, on SQL Server 2005 or 2008. Note, however, that the data is slightly different in the AdventureWorks database from what’s stored in the AdventureWorks2008 database, so your results will be different than what is shown here. Otherwise, most of the examples will run fine.

UPDATE Syntax

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Here Is An Example Related To Topic

Step 1 :Create database

Create database Demo

Step 2:Create table

Here In This step We Will Create table.

Here In This Step We Required Four Column With Name eds ,ename ,elocation and esalary  using Parameter bigint,varchar and float.


create table employee
(
eds bigint,
ename varchar(50),
elocation varchar(50),
esalary float
);

Step 3 :Create Insert Trigger Functionality

Here In This Step We Will Insert Data Using Insert Command.
Data Will Be Added Manually Using Insert Command.


Insert Into employee values(1,'VIRAJ','DADAR',10000.00)

select *from employee

Step 4 :Create Update  Trigger Functionality

Here In This Step We Will Insert Data Using Update Command.
Data Will Be Added Manually Using Update Command.

Here We Will Update Data Based On eds Using Where Condition.



Update employee
set ename='RAJ',
elocation='ANDHERI',
esalary=15000.00
Where eds=1




select *from employee

HERE IS THE VIDEO RELATED TO THE TOPIC