API UpdateTECDOC Brands - Historie editací

Chrzaszcz v 22. 9. 2017, 08:41

2017-09-22T08:41:24Z

Chrzaszcz v 2. 8. 2017, 07:38

2017-08-02T07:38:28Z

Chrzaszcz v 2. 8. 2017, 07:38

2017-08-02T07:38:02Z

Chrzaszcz v 2. 8. 2017, 07:32

2017-08-02T07:32:22Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update TecDoc brands in system. ==== Exact name ==== `API_UpdateTECDOC_Brands` ==== Type ==== Stand…“

2017-08-02T07:31:26Z

Založena nová stránka s textem „==== Description ==== Method allows You to update TecDoc brands in system. ==== Exact name ==== <code>API_UpdateTECDOC_Brands</code> ==== Type ==== Stand…“

Nová stránka

==== Description ====
Method allows You to update TecDoc brands in system.

==== Exact name ====
<code>API_UpdateTECDOC_Brands</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@TecDocID
|int
|
|TecDoc ID
|
|-
|@Name
|nvarchar(80)
|
|Name
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID INT
DECLARE @TecDocID INT
DECLARE @Name nvarchar(255)

SELECT @ID = id,
@TecDocID = 300,
@Name = [Name]
FROM [API_GetTecDocBrands]
WHERE id = 3

EXECUTE [API_UpdateTECDOC_Brands]
@ID,
@TecDocID,
@Name

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 35: / Řádka 35: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID INT
   DECLARE @TecDocID INT
@@ Řádka 48: / Řádka 52: @@
   WHERE  ID = 3
-  EXECUTE [API_UpdateTECDOC_Brands]
+  EXECUTE @return_value = [API_UpdateTECDOC_Brands]
    @ID,
    @TecDocID,

@@ Řádka 46: / Řádka 46: @@
         @Name = [Name]
   FROM   [API_GetTecDocBrands]
-  WHERE  id = 3
+  WHERE  ID = 3
   EXECUTE [API_UpdateTECDOC_Brands]

@@ Řádka 42: / Řádka 42: @@
   DECLARE @Name nvarchar(255)
-  SELECT @ID = id,
+  SELECT @ID = [ID],
         @TecDocID = 300,
         @Name = [Name]

@@ Řádka 15: / Řádka 15: @@
 !Description
 !Relation
 |-
 |@TecDocID

API UpdateTECDOC Brands - Historie editací

Chrzaszcz v 22. 9. 2017, 08:41

Chrzaszcz v 2. 8. 2017, 07:38

Chrzaszcz v 2. 8. 2017, 07:38

Chrzaszcz v 2. 8. 2017, 07:32

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update TecDoc brands in system. ==== Exact name ==== API_UpdateTECDOC_Brands ==== Type ==== Stand…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update TecDoc brands in system. ==== Exact name ==== `API_UpdateTECDOC_Brands` ==== Type ==== Stand…“