set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[StpEditPrintLayout] ( @LayoutName nvarchar(50), @PrimaryLayout bit, @ID int ) AS Begin UPDATE PrintLayouts SET LayoutName = @LayoutName, PrimaryLayout = @PrimaryLayout WHERE (ID = @id) END