Chrzaszcz v 20. 9. 2017, 14:12

2017-09-20T14:12:28Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update workshop in system. ==== Exact name ==== `API_UpdateWorkshop` ==== Type ==== Standard execut…“

2017-08-02T14:26:36Z

Založena nová stránka s textem „==== Description ==== Method allows You to update workshop in system. ==== Exact name ==== <code>API_UpdateWorkshop</code> ==== Type ==== Standard execut…“

Nová stránka

==== Description ====
Method allows You to update workshop in system.

==== Exact name ====
<code>API_UpdateWorkshop</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@Name
|nvarchar(250)
|
|Name
|
|-
|@Street
|nvarchar(200)
|
|Street
|
|-
|@City
|nvarchar(120)
|
|City
|
|-
|@ZIPCode
|nvarchar(15)
|
|ZIP code
|
|-
|@Country
|nvarchar(70)
|
|Country
|
|-
|@Region
|nvarchar(70)
|
|Region
|
|-
|@State
|nvarchar(80)
|
|State
|
|-
|@StateID
|int
|
|ID of country from country list (see relation)
|API_GetCountry.ID
|-
|@PhoneNumber
|nvarchar(50)
|
|Phone number
|
|-
|@Fax
|nvarchar(50)
|
|Fax
|
|-
|@MobilePhone
|nvarchar(50)
|
|MobilePhone
|
|-
|@Email
|nvarchar(70)
|
|Email
|
|-
|@Web
|nvarchar(120)
|
|Web
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @Name nvarchar(250)
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 @PhoneNumber nvarchar(50)
DECLARE @Fax nvarchar(50)
DECLARE @MobilePhone nvarchar(50)
DECLARE @Email nvarchar(70)
DECLARE @Web nvarchar(150)

SELECT @ID = [ID],
@Name = 'Name 2',
@Street = [Street],
@City = [City],
@ZIPCode = [ZIPCode],
@Country = [Country],
@Region = [Region],
@State = [State],
@StateID = [StateID],
@PhoneNumber = [PhoneNumber],
@Fax = [Fax],
@MobilePhone = [MobilePhone],
@Email = [Email],
@Web = [Web]
FROM [API_GetWorkshops]
WHERE id = 1

EXECUTE [API_UpdateWorkshop]
@ID,
@Name,
@Street,
@City,
@ZIPCode,
@Country,
@Region,
@State,
@StateID,
@PhoneNumber,
@Fax,
@MobilePhone,
@Email,
@Web

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 101: / Řádka 101: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @Name nvarchar(250)
@@ Řádka 136: / Řádka 140: @@
   WHERE  id = 1
-  EXECUTE [API_UpdateWorkshop]
+  EXECUTE @return_value = [API_UpdateWorkshop]
    @ID,
    @Name,

API UpdateWorkshop - Historie editací

Chrzaszcz v 20. 9. 2017, 14:12

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update workshop in system. ==== Exact name ==== API_UpdateWorkshop ==== Type ==== Standard execut…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update workshop in system. ==== Exact name ==== `API_UpdateWorkshop` ==== Type ==== Standard execut…“