IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_DBImportTestSetupObjectMetaData]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_DBImportTestSetupObjectMetaData]
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].[sp_DBImportTestSetupObjectMetaData]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_DBImportTestSetupObjectMetaData] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_DBImportTestSetupObjectMetaData]
		 @TestSetupId		int
		,@MetaData			xml
AS
BEGIN
		insert into [dbo].[TestSetupObjectMetaData]
				   ([TestSetupId]
				   ,[ISOTestObject]
				   ,[PropName]
				   ,[PropValue]
				   ,[Optional]
				   ,[Version])
		select		@TestSetupId
					, t.x.value('(@TestObject)', 'nvarchar(1)')
					, t.x.value('(@PropName)', 'nvarchar(255)')
					, t.x.value('(@PropValue)', 'nvarchar(255)')
					, t.x.value('(@Optional)', 'bit')
					, t.x.value('(@Version)', 'float')
		from @MetaData.nodes('/MetaDatas/MetaData') t(x)
END
	



























GO