API UpdateBranch: Porovnání verzí

Verze z 24. 7. 2017, 14:14

API_UpdateBranch

@ID int - API_GetBranches.ID
@WorkshopID int - API_GetWorkshops.ID
@Name nvarchar(100)
@Street nvarchar(200)
@City nvarchar(120)
@ZIPCode nvarchar(15)
@Country nvarchar(70)
@Region nvarchar(70)
@State nvarchar(80)
@StateID int - API_GetCountry.ID
@Phone nvarchar(50)
@Fax nvarchar(50)
@MobilePhone nvarchar(50)
@Email nvarchar(70)
@Web nvarchar(120)

Example:

DECLARE @ID INT 
DECLARE @WorkshopID INT 
DECLARE @Name NVARCHAR(100) 
DECLARE @Street NVARCHAR(200) 
DECLARE @City NVARCHAR(120) 
DECLARE @ZIPCode NVARCHAR(15) 
DECLARE @Country NVARCHAR(70) 
DECLARE @Region NVARCHAR(70) 
DECLARE @State NVARCHAR(80) 
DECLARE @StateID INT 
DECLARE @Phone NVARCHAR(50) 
DECLARE @Fax NVARCHAR(50) 
DECLARE @MobilePhone NVARCHAR(50) 
DECLARE @Email NVARCHAR(70) 
DECLARE @Web NVARCHAR(120) 

SELECT @ID = id, 
      @WorkshopID = [workshopid], 
      @Name = 'Name2', 
      @Street = [street], 
      @City = [city], 
      @ZIPCode = [zipcode], 
      @Country = [country], 
      @Region = [region], 
      @State = [state], 
      @StateID = [stateid], 
      @Phone = [phone], 
      @Fax = [fax], 
      @MobilePhone = [mobilephone], 
      @Email = [email], 
      @Web = [web] 
FROM   [api_getbranches] 
WHERE  id = 3

EXECUTE [Api_updatebranch] 
 @ID, 
 @WorkshopID, 
 @Name, 
 @Street, 
 @City, 
 @ZIPCode, 
 @Country, 
 @Region, 
 @State, 
 @StateID, 
 @Phone, 
 @Fax, 
 @MobilePhone, 
 @Email, 
 @Web