API GetBranches - Historie editací

Chrzaszcz v 25. 7. 2017, 13:51

2017-07-25T13:51:26Z

Chrzaszcz: /* Specification */

2017-07-25T12:55:26Z

‎Specification

Chrzaszcz v 25. 7. 2017, 12:16

2017-07-25T12:16:18Z

Chrzaszcz v 25. 7. 2017, 07:15

2017-07-25T07:15:40Z

Zavadil v 24. 7. 2017, 16:25

2017-07-24T16:25:18Z

Chrzaszcz v 24. 7. 2017, 12:39

2017-07-24T12:39:33Z

Chrzaszcz v 24. 7. 2017, 12:16

2017-07-24T12:16:25Z

Chrzaszcz: Založena nová stránka s textem „ API_GetBranches , , , , ,…“

2017-07-24T12:15:51Z

Založena nová stránka s textem „ API_GetBranches ,<ID, int,> ,<WorkshopID, int,> ,<Name, nvarchar(100),> ,<Street, nvarchar(200),> ,…“

Nová stránka

API_GetBranches
,<ID, int,>
,<WorkshopID, int,>
,<Name, nvarchar(100),>
,<Street, nvarchar(200),>
,<City, nvarchar(120),>
,<ZIPCode, nvarchar(15),>
,<Country, nvarchar(70),>
,<Region, nvarchar(70),>
,<State, nvarchar(80),>
,<StateID, int,>
,<Phone, nvarchar(50),>
,<Fax, nvarchar(50),>
,<MobilePhone, nvarchar(50),>
,<Email, nvarchar(70),>
,<Web, nvarchar(150),>

Example:
SELECT TOP 1000 *
FROM [API_GetBranches]

@@ Řádka 1: / Řádka 1: @@
 ==== Description ====
-Method gives You overview of existing branches in system
+Method gives You overview of existing branches in system.
 ==== Exact name ====

@@ Řádka 42: / Řádka 42: @@
 |ZIPCode
 |nvarchar(15)
-|ZIPCode
+|ZIP code
+|
 |-

@@ Řádka 22: / Řádka 22: @@
 |WorkshopID
 |int
-|Workshop ID
+|ID of workshop from workshop list (see relation)
 |API_GetWorkshops.ID
 |-
@@ Řádka 33: / Řádka 32: @@
 |Street
 |nvarchar(200)
+|Street
+|
 |-
 |City
 |nvarchar(120)
+|City
+|
 |-
 |ZIPCode
 |nvarchar(15)
+|ZIPCode
+|
 |-
 |Country
 |nvarchar(70)
+|Country
+|
 |-
 |Region
 |nvarchar(70)
+|Region
+|
 |-
 |State
 |nvarchar(80)
+|State
+|
 |-

@@ Řádka 28: / Řádka 28: @@
 |Name
 |nvarchar(100)
-|Workshop name
+|Branch name
+|
 |-

@@ Řádka 1: / Řádka 1: @@
-'''API_GetBranches'''
+==== Exact name ====
-           <ID, int,>
+<code>API_GetBranches</code>
-''Example:''
+==== Example ====
- SELECT TOP 1000 *
+<syntaxhighlight lang="sql">
- FROM [API_GetBranches]
+SELECT TOP 1000 * FROM [API_GetBranches]