Tuesday, August 17, 2010

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

1 comment:

Anonymous said...

Magnificent goods from you, man. I've understand your stuff previous to and you are just extremely great. I actually like what you have acquired here, certainly like what you're stating and
the way in which you say it. You make it enjoyable and you still take care of to keep it sensible.
I can't wait to read far more from you. This is really a great web site.
my web site: perfumes baratos