Stored Procedure
Cấu trúc đơn giản :
CREATE PROC [Ten]
@[TenThamSo] [LoaiThamSo] AS 'Các câu lệnh muốn thực thi
GO
Vd :
CREATE PROC uspGetAddress
@City nvarchar(30)
AS
SELECT * FROM AdventureWorks.Person.Address WHERE City = @City
GO
CREATE PROC [Ten]
@[TenThamSo] [LoaiThamSo] AS 'Các câu lệnh muốn thực thi
GO
Vd :
CREATE PROC uspGetAddress
@City nvarchar(30)
AS
SELECT * FROM AdventureWorks.Person.Address WHERE City = @City
GO
