Experimental Six SQL Server 2000 / 7.0 Storage Procedure and Database Backup
1. Create a stored procedure
1. Create a stored procedure
(1) Establish a stored procedure in Enterprise Manager.
(2) Set the stored procedure with the creation stored procedure wizard.
2. View and modify the stored procedure
3. Delete stored procedure
(1) Remove the stored procedure in Enterprise Manager.
(2) Delete stored procedures with SQL statement
Drop Procedure INSERT_S
Go
4. Use stored procedures
4. Use stored procedures
Execute INSERT_S @SnO = '9801', @ sname = "Li Ming", @ Age = "19", @ sex = "Men", @ SDEPT = "Computer Software"
5. Database backup and recovery
Right click on the database name you need to back up, select Backup Database, and then go to the backup database box
Then select the option of the backup, which can be a full backup, or an incremental backup, add a backup purpose (must), and finally click OK to start the backup.
SQL statement in this experiment
See
Steps to illustrate the backup and recovery of the database
See
Machine
Database experiments have all been completed, and the understanding of SQL Sever is not available, from contact with familiarity. Although this experiment is very simple, it is very practical, and the stored procedure is important for a database. Just starting to create a stored procedure is still very sparsely, but through the narrative in the book, step down step down step down, and repeated practice practice, and finally, it is still more satisfied with the experimental results, I hope to continue to contact SQL in the future. Sever.
