API CreateBranch: Porovnání verzí

Verze z 24. 7. 2017, 13:57

API_CreateBranch

@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:

EXEC [API_CreateBranch] 
  @WorkshopID = 1
 ,@Name = 'Name'
 ,@Street = 'Street'
 ,@City = 'City'
 ,@ZIPCode = 'ZIPCode'
 ,@Country = 'Country'
 ,@Region = 'Region'
 ,@State ='Česká republika'
 ,@StateID = 15797
 ,@Phone = '+420 556 621 300'
 ,@Fax = '+420 596 790 789'
 ,@MobilePhone = '+420 556 621 301'
 ,@Email = 'info@nextis.cz'
 ,@Web = 'www.nextis.cz'