51 lines
3.5 KiB
Plaintext
51 lines
3.5 KiB
Plaintext
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[foo_DBExport]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
|
|
DROP FUNCTION [dbo].[foo_DBExport]
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[foo_DBExport]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
|
|
BEGIN
|
|
execute dbo.sp_executesql @statement = N'CREATE FUNCTION [dbo].[foo_DBExport]
|
|
(
|
|
)
|
|
RETURNS xml
|
|
AS
|
|
BEGIN
|
|
declare @DataProVersion int
|
|
SELECT TOP 1 @DataProVersion = [Version] FROM [dbo].[DataPRODbVersion]
|
|
|
|
RETURN isnull(
|
|
|
|
(select @DataProVersion as [Version]
|
|
, [dbo].[foo_DBExportCustomerDetails]()
|
|
, [dbo].[foo_DBExportTestEngineerDetails]()
|
|
, [dbo].[foo_DBExportLabDetail]()
|
|
, [dbo].[foo_DBExportDAS]()
|
|
, [dbo].[foo_DBExportSensorModel]()
|
|
, [dbo].[foo_DBExportSensors]()
|
|
, [dbo].[foo_DBExportSensorCalibration]()
|
|
, [dbo].[foo_DBExportGroupTemplate]()
|
|
, [dbo].[foo_DBExportGroups]()
|
|
, [dbo].[foo_DBExportMMEDirections]()
|
|
, [dbo].[foo_DBExportMMEFilterClasses]()
|
|
, [dbo].[foo_DBExportMMEFinLoc1]()
|
|
, [dbo].[foo_DBExportMMEFinLoc2]()
|
|
, [dbo].[foo_DBExportMMEFinLoc3]()
|
|
, [dbo].[foo_DBExportMMEMainLocation]()
|
|
, [dbo].[foo_DBExportMMEPhysicalDimensions]()
|
|
, [dbo].[foo_DBExportMMEPositions]()
|
|
, [dbo].[foo_DBExportMMEPossibleChannels]()
|
|
, [dbo].[foo_DBExportTestSetup]()
|
|
, [dbo].[foo_DBExportUsers]()
|
|
, [dbo].[foo_DBExportGlobalSettings]()
|
|
for xml path(''''), root(''ExportFile''), BINARY BASE64), ''<ExportFile />'')
|
|
|
|
|
|
END
|
|
'
|
|
END
|
|
|
|
GO
|