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