update and delete query using sql server 2014

Update & Delete Query 



http://dotnetdrizzles.blogspot.in/2014/09/delete-query-in-sql-server-using-aspnet.html


http://dotnetdrizzles.blogspot.in/2014/09/update-query-in-sql-server-using-aspnet.html

To update and delete you need a unique identity column first on that basis you can update and delete.

lets say u have name as unique identity on that basis i will give you query of both.

To update ....

update tablename set column name1 = "value", columnname2="value" where columnname="unique identity";
 now according to your table.....the update query will be:-

update First set Address="Nepal",Number="4567687" where Name="Irfan";

_______________________________________________________________

now similarly to delete query will be:-

Delete * from First where Name="Irfan";

_________________________________________________________________

if any doubt then reply me.
Regards.