USE [Vertragsverwaltung_20160404] GO /****** Object: StoredProcedure [dbo].[sp_get_TabControlMultiline] Script Date: 02.12.2016 09:08:53 ******/ DROP PROCEDURE [dbo].[sp_get_TabControlMultiline] GO /****** Object: StoredProcedure [dbo].[sp_get_TabControlMultiline] Script Date: 02.12.2016 09:08:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= CREATE PROCEDURE [dbo].[sp_get_TabControlMultiline] @tabcontrolname varchar(255), @multiline int output AS BEGIN select @multiline=isnull(multiline,0) from TabControlMultiline where TabControlName=@tabcontrolname and Aktiv=1 END GO