Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- bài 1
- --create proc dbo.GetInfoCust
- --@cusid as nchar(5)
- --as
- --select *from dbo.Customers
- --where CustomerID = @cusid
- --go
- --exec dbo.GetInfoCust N'ALFKI'
- -- bài 2
- --create proc dbo.insertTer
- --@terID as varchar(20),
- --@terDes as nchar(50),
- --@regID as int
- --as
- -- insert into dbo.Territories(TerritoryID,TerritoryDescription,RegionID )
- -- values ( @terID, @terDes , @regID )
- --exec dbo.insertTer '13579','hello',3
- --go
- --select *from Territories
- --where TerritoryID ='13579'
- --bài 2 ( mẫu by GV )
- --alter proc Territoies_Themmoi(@TerritoryID nvarchar(20) , @TerritoryDescription nchar(50), @RegionID int )
- --as
- --begin
- -- insert into Territories (TerritoryID, TerritoryDescription , RegionID)
- -- values ( @TerritoryID, @TerritoryDescription, @RegionID )
- --return
- --end
- -- bài 3 :
- --create proc dbo.Territories_Themmoi(@TerritoryID nvarchar(20) , @TerritoryDescription nchar(50), @RegionID int )
- --as
- --begin
- -- declare @t int
- -- set @t=0 ;
- -- select @t-count(*)
- -- from Region
- -- where RegionID = @RegionID
- -- if @t=0
- -- raiserror (' Lỗi khóa ngoại, chưa tồn tại Region',16,0)
- -- end
- -- insert into Territories ( TerritoryID, TerritoryDescription , RegionID)
- -- values ( @TerritoryID, @TerritoryDescription, @RegionID )
- -- print N'Thêm mới thành công'
- --return
- --Territories_Themmoi N'HN' ,N'Hà Nội' ,4
- -- Bài 4
- --create proc dbo.Territories_ThemMoi3(@TerritoryID nvarchar(20), @TerritoryDescription nchar(50), @RegionID int)
- --as
- --begin
- -- begin Try
- -- insert into Territories (TerritoryID, TerritoryDescription, RegionID)
- -- values (@TerritoryID, @TerritoryDescription, @RegionID)
- -- end try
- -- Begin Catch
- -- if(Error_number()=547)
- -- print N'Lỗi thêm mới, khóa chưa tồn tại'
- -- else
- -- print N'Lỗi thêm mới, không phải lỗi khóa ngoại'
- -- End Catch
- --end
- --return
- --Territories_ThemMoi3 N'N', N'Hài ', 5
- --Bài 9 :
- --create function dbo.DSHDtheoKH (@CustomerID nchar(5) )
- --returns varchar (250)
- --as
- --begin
- -- declare @ds varchar(250)
- -- set @ds='';
- -- select @ds =@ds + CAST(OrderID as varchar ) + ';'
- -- from Orders
- -- where CustomerID = @CustomerID
- -- return @ds;
- --end
- --go
- --select dbo.DSHDtheoKH(N'ALFKI') as DSHD
- select distinct CustomerID, dbo.DSHDtheoKH(CustomerID)as DSHD
- from Orders
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement