CREATE PROC PU_B(@M VARCHAR(20)
AS
BEGINEXEC('UPDATE tabMonth
SET CurrentMonth=(select right('+@M+',6))')
END
GOEXEC PU_B 'TAB200709'列名 'TAB200709' 无效。
AS
BEGINEXEC('UPDATE tabMonth
SET CurrentMonth=(select right('+@M+',6))')
END
GOEXEC PU_B 'TAB200709'列名 'TAB200709' 无效。
AS
BEGINEXEC('UPDATE tabMonth
SET CurrentMonth=(select right('''+@M+''',6))')
END
GO
AS
EXEC('UPDATE tabMonth SET CurrentMonth=right('''+@M+''',6)')
GO
AS
EXEC('UPDATE tabMonth SET CurrentMonth=right('''+@M+''',6)')
GO
alter PROC PU_B(@M VARCHAR(20))
AS
BEGINexec('UPDATE tabMonth
SET CurrentMonth= right('''+@M+''',6)')
END
GOEXEC PU_B 'TAB200709'
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROC PU_B(@M VARCHAR(20))
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; UPDATE tabMonth SET CurrentMonth=right(@M,6)
END
GO