dbo.DA_GetBodyRegionViewList.StoredProcedure.sql
2.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[DA_GetBodyRegionViewList] Script Date: 2/1/2018 12:15:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: magic
-- Create date: 25/4/2009
-- Description: Get BodyRegionViewList
-- =============================================
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DA_GetBodyRegionViewList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DA_GetBodyRegionViewList]
GO
CREATE PROCEDURE [dbo].[DA_GetBodyRegionViewList]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT
(SELECT Id as id, BodyViewId as voId, RegionId as brId,Zorder as zr, Zoom as zm,
OffsetX as ox, OffsetY as oy, Width as wd, Height as ht,
ISNULL(IsMirrored, 'N') as ismr,
ISNULL(MirrorOffset, 0) as mro,
IsPrimary as isp, CanvasBounds as cnb
FROM DissectibleRegionView it
ORDER BY BodyViewId, Zorder, RegionId
FOR XML AUTO)
as XMLString
END
GO