Creating simple Update stored procedure

Here you can learn how to create a simple stored procedure..

You should follow the below step after login in sql server.
Be sure that you are logged in sql server.


SIMPLE UPDATE QUERY.

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

Create procedure updatelogin
@id varchar(50),
@name varchar(50),
@pass varchar(50)
as

Update logintable set name=@name,passsword=@pass where id=@id

Here name password and id are logintable field name.

Here updatelogin is a stored procedure name and logintable is table name.

After writing the code press F5. or select Execute query.

You will get a message as shown here.

Here is the way how to see stored procedure.



After refreshing you will get your stored procedure with prefix dbo.procedurename

Enjoy….

google

My Linked Profile
Submit your site
Submit your site to listtheweb.com