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

Creating simple delete 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 DELETE QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

create procedure deletelogin
@id varchar(50)
as
Delete from logintable where id=@id

Here deletelogin 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

Get higher pagerank
Get higher pagerank by submitting to our directory

Creating simple SELECT 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 SELECT QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

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

create procedure selectlogin

@id varchar(50)

as

select * from logintable where id=@id

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

@FaceBook

Creating simple 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 INSERT QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

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

Create procedure mylogin

@id varchar(50),

@name varchar(50),

@pass varchar(50)

as

insert into logintable values(@id,@name,@pass)

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

Get higher pagerank
Get higher pagerank by submitting to our directory

Step by Step stored procedure

A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a proc, sproc, StoPro, or SP) are actually stored in the database data dictionary.

A stored procedure is a procedure (like a subprogram in a regular computing language) that is stored (in the database). Correctly speaking, MySQL supports "routines" and there are two kinds of routines: stored procedures which you call, or functions whose return values you use in other SQL statements the same way that you use pre-installed MySQL functions like pi(). I'll use the word "stored procedures" more frequently than "routines" because it's what we've used in the past, and what people expect us to use.


Step by step procedure to create a stored procedure
Step-1
Open Microsoft sqlserver
Login into that

Step-2

Select new query or any one below of that

Step-3

Write a procedure as shown here

&

Execute that query as shown here

Step-5
Hear you can see that stored procedure

See Status of the blog