USP_IMAGEALBUM_IMAGES_BULKSETSEQUENCE
The save procedure used by the add dataform template "ImageSequence Add Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | INOUT | The output parameter indicating the ID of the record added. |
| @SEQUENCE | xml | IN | Sequence Data |
Definition
Copy
CREATE procedure dbo.USP_IMAGEALBUM_IMAGES_BULKSETSEQUENCE
(
@ID int output,
@SEQUENCE xml = null
)
as
set nocount on;
update dbo.ImageAlbum_Images
set Sequence = IMAGES.IMG.value('@sequence', 'int')
from dbo.ImageAlbum_Images IAI
inner join @SEQUENCE.nodes('/images/image') IMAGES(IMG) on IMAGES.IMG.value('@id', 'int') = IAI.SiteImageID
where IAI.ImageAlbumID = @ID
return 0