-- ================================================
-- Template generated
from Template Explorer
using:
--
Create Procedure (New Menu).SQL
--
-- Use the Specify Values
for Template Parameters
-- command (Ctrl-Shift-M) to fill
in the parameter
--
values below.
--
-- This block of comments will not be included
in
--
the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
--
Author:
--
Create date:
--
Description:
-- =============================================
CREATE PROCEDURE dbo.testP --
存储过程名
-- Add the parameters
for the stored procedure here
@pOfficeName varchar(16),@pReMark varchar(
16)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets
from
--
interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements
for procedure here
insert into dbo.T_Office(OfficeName,ReMark) values (@pOfficeName,@pReMark);
END
GO
转载于:https://www.cnblogs.com/luyuxibaby/p/5217325.html
相关资源：SQLServer存储过程
