TAILIEUCHUNG - Create Stored Procedures

2,7 Tạo thủ tục lưu trữ Thủ tục lưu trữ cho phép bạn thực hiện số lượng lớn trên các hồ sơ, chẳng hạn như cập nhật, chèn, và xóa dữ liệu khi cần thiết | Create Stored Procedures Stored procedures allow you to perform bulk operations on records such as updating inserting and deleting data as needed. This tutorial shows you how to create stored procedures as well as how to test them from within the Server Explorer. Viewing data is great but you need to perform bulk operations such as adding updating and deleting records. You know that you will be using a stored procedure to perform these tasks and you will be using them more than once in your application. How do you create stored procedures from VS Technique Stored procedures are the way to go when you want add delete or update records or when you want to use a parameter. When you have a task that requires multiple actions including temporary tables stored procedures give you this ability. Stored procedures are powerful to use and easy to create. Note To create stored procedures you will use what is called Transact-SQL T-SQL . Although this chapter will present some simple commands to show the interface used to create stored procedures from VS .NET Chapter 6 Creating Transact-SQL Commands goes into more detail on the commands of the language. As with views you will use a designer within Visual Studio. Unlike the Views designer the stored procedure designer is not visual initially but more text oriented. However you can pull up a visual designer after you are in the text designer. When you re creating a new stored procedure you will right-click on the Stored Procedures node in the database to which you want to add the stored procedure and then you will choose New Stored Procedure. To edit existing stored procedures you will highlight the stored procedure right-click and choose Edit Stored Procedure. After the stored procedure is open you will see a select statement or a number of T-SQL statements. If it is a new stored procedure you can right-click and choose Insert SQL. You will be taken to the Query Builder which happens to look like the View designer. If it is

• Cơ sở dữ liệu
• công nghệ máy tính
• phần mềm
• kỹ thuật lập trình
• lập trình
• dữ liệu
• Create Stored Procedures
• Phần cứng máy tính
• lắp ráp máy tính
• sửa chữa máy tính
• lỗi máy tính
• hệ thống mạch máy tính
• điện máy tính
• Tài liệu máy tính