SQL server 存储过程的编写

最新推荐文章于 2024-08-09 14:18:49 发布

予非池物

最新推荐文章于 2024-08-09 14:18:49 发布

阅读量2k

点赞数

分类专栏：数据库文章标签：数据

本文链接：https://blog.csdn.net/qq_40155090/article/details/81083909

版权

数据库专栏收录该内容

7 篇文章 1 订阅

订阅专栏

USE [数据库名称]

GO
/****** Object: StoredProcedure [dbo].[insertbGait] Script Date: 2018/7/17 15:51:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:       liulaiyang
-- Create date: 20180704
-- Description:   test
-- =============================================
CREATE PROCEDURE [dbo].[insert+表名]
   -- Add the parameters for the stored procedure here

   @id   bigint out, //@加字段数据类型，
   @gain    nvarchar,
   @image   varbinary(MAX)NULL=NULL   ,
AS
BEGIN
   -- SET NOCOUNT ON added to prevent extra result sets from
   -- interfering with SELECT statements.
   SET NOCOUNT ON;

-- Insert statements for procedure here
   DECLARE @MyTableVar table( id bigint);
   BEGIN TRY
       INSERT INTO bGait(gait,image)//对应字段
           output inserted.id into @MyTableVar
           VALUES(@gain,@image)//@+对应字段
       SET @id = (SELECT TOP 1 id FROM @MyTableVar)
   END TRY
   BEGIN CATCH
       RETURN 0
   END CATCH
END
RETURN 1