1and1 Help Centre Categories

print article

Manage Stored Procedures with myLittleAdmin

For Windows packages.

In this article we will show you how to create, edit and delete stored procedures in MSSQL.

Follow the steps below to either create stored procedures, make changes to them or drop them.

Create Stored Procedures
Step 1
Step 2
Click Databases and select your database.
myLittleAdmin > Databases > your database
myLittleAdmin > Databases > your database
Step 3
Select Stored Procedures and click the star icon on the right to create a new stored procedure.
Your database > Stored Procedures > star icon
Your database > Stored Procedures > star icon
Step 4
Enter your statement and click Create.
New Stored Procedure window in which to type the statement > Create
New Stored Procedure window in which to type the statement > Create
Edit Stored Procedures
Step 1
Step 2
Click Databases and select your database.
myLittleAdmin > Databases > your database
myLittleAdmin > Databases > your database
Step 3
Select Stored Procedures and click the edit icon for the stored procedure you want to edit.
Your database > Stored Procedures > edit icon
Your database > Stored Procedures > edit icon
Delete Stored Procedures
Step 1
Step 2
Click Databases and select your database.
myLittleAdmin > Databases > your database
myLittleAdmin > Databases > your database
Step 3
Select Stored Procedures and click the red X icon to delete the stored procedure.
Your database > Stored Procedures > X icon
Your database > Stored Procedures > X icon
For additional information, you may want to reference: