API UpdateTECDOC Brands: Porovnání verzí
Z Podpora.nextis.cz
Řádka 46: | Řádka 46: | ||
@Name = [Name] | @Name = [Name] | ||
FROM [API_GetTecDocBrands] | FROM [API_GetTecDocBrands] | ||
− | WHERE | + | WHERE ID = 3 |
EXECUTE [API_UpdateTECDOC_Brands] | EXECUTE [API_UpdateTECDOC_Brands] |
Verze z 2. 8. 2017, 08:38
Description
Method allows You to update TecDoc brands in system.
Exact name
API_UpdateTECDOC_Brands
Type
Standard executable stored procedure.
Specification
Parameter | Data type | Value range | Description | Relation |
---|---|---|---|---|
@ID | int | Internal system id | ||
@TecDocID | int | TecDoc ID | ||
@Name | nvarchar(80) | Name |
Example
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
Notices
None.