SQL存储过程

最新推荐文章于 2022-10-12 20:13:54 发布
最新推荐文章于 2022-10-12 20:13:54 发布
阅读量999 收藏 2
点赞数
分类专栏： SQLSERVER 文章标签： sql 存储 insert menu 数据库 output
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zst126/article/details/1926779
版权

1、拆分字符串

IF EXISTS(SELECT NAME FROM sysobjects
 WHERE NAME = N'procInsertOrderInfoOrderList' AND Type = N'P')
DROP PROCEDURE procInsertOrderInfoOrderList
GO

CREATE PROCEDURE procInsertOrderInfoOrderList
   (
 @Did NVARCHAR(1000),   --餐桌号(团体时为字符串)
 @Mid NVARCHAR(4000),   --非套餐时为:菜单号或拼音(字符串),套餐时为:套餐号
 @Onum NVARCHAR(4000),  --非套餐时为:各个菜的数量(字符串),套餐时为:套餐的数量1
 @Onume INT,    --餐桌实做人数
 @Uid INT,    --终端下单服务员员工编号
 @OremarkList NVARCHAR(4000), --菜的备注(字符串)
 @Oflag BIT,    --是否套餐标志{(0,非套餐),(1,套餐)}
 @Nstatus BIT    --用于判断是团体还是个人{(0,个人),(1,团体)}
   )
AS
BEGIN
 DECLARE @dt NVARCHAR(1000)  --用于存放拆分后的餐桌号
 DECLARE @rt NVARCHAR(4000)  --用于存放拆分后的菜单号
 DECLARE @rt1 NVARCHAR(4000)  --存放拆分后的菜的备注
 DECLARE @rt2 NVARCHAR(4000)  --用于存放拆分后的数量
 DECLARE @Orid NVARCHAR(20) --要插入数据库中的订单号
 DECLARE @Did1 INT   --要插入数据库中的餐桌号
 DECLARE @OIid INT   --要插入数据库中的订单号对应的记录号 
 DECLARE @Mid1 INT   --要插入数据库中的菜单号
 DECLARE @BLid INT   --要插入数据库中的套餐号
 DECLARE @MPrice1 MONEY  --要插入数据库中的价格
 DECLARE @Mname1 NVARCHAR(20) --存储菜单对应的拼音
 DECLARE @Oremark NVARCHAR(200) --要插入数据库中的菜的备注
 DECLARE @count INT   --用于统计餐桌的个数
 DECLARE @count1 INT   --统计菜单的个数
 DECLARE @count2 INT   --统计一个餐桌上相同菜的个数
 DECLARE @mm INT   --用于循环餐桌的个数
 DECLARE @nn INT   --用于循环插入菜单的个数
 DECLARE @i INT   --用于处理拆分调用SUBSTRING的个数
 DECLARE @ii INT   --用于处理拆分调用SUBSTRING的个数
 DECLARE @timeID NVARCHAR(17) --获取时间唯一标示
 DECLARE @OrderInfoDid INT  --用于团体开单时取同一个订单号
 DECLARE @FirstYN INT   --判断是开单还是加菜{(0,开单),(大于0,加菜)}
 DECLARE @DidYN INT   --存储接收处理后的餐桌号，用于判断是第一次开单还是加菜
 DECLARE @Mflag INT   --根据Mid取Mflag
 DECLARE @update_D_rowcount INT
 DECLARE @update_D_error INT
 DECLARE @insert_OI_error INT
 DECLARE @insert0_OL_error INT
 IF( @Oflag = 0 )    --非套餐
 BEGIN     --(非套餐BEGIN)
 IF( @Nstatus = 0 )   --个人开单  
 BEGIN     --(个人开单BEGIN)
 SELECT @DidYN = CAST(@Did AS INT)
 SELECT
  @FirstYN = COUNT(Did)
 FROM
  OrderInfo
 WHERE
  ( Did = @DidYN )
  AND( Ostatus = 0 )
 IF(@FirstYN = 0)   --个人第一次开单
 BEGIN    --(个人第一次开单BEGIN)
  EXECUTE procGetTimeID @timeID OUTPUT
  SELECT @Orid =N'P'+@timeID
  SELECT @Did1 = CAST(@Did AS INT)
  --修改餐桌状态为"使用中"
  BEGIN TRANSACTION
  UPDATE
    DingingTable
  SET
   Dstatus = 3
  WHERE
    ( Did = @Did1 )
   AND( Dstatus IN(1,2) )
  SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
  INSERT INTO OrderInfo( Orid,Did,Onum,Uid ) 
   VALUES( @Orid,@Did1,@Onume,@Uid )
  SELECT @insert_OI_error = @@ERROR
  SELECT @OIid = IDENT_CURRENT('OrderInfo')
  SELECT @count1 = LEN(@Mid)-LEN(REPLACE(@Mid,',',''))+1
  SET @nn = 1
  SET @i = 1
  WHILE(@nn <= @count1)
  BEGIN
  SET @Mid = @Mid + ','
  SET @OremarkList = @OremarkList + ','
  SET @Onum = @Onum + ','
  IF(@nn = 1)
   BEGIN
    SET @rt=LEFT(@Mid,CHARINDEX(',',@Mid)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜的编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SET @rt1=LEFT(@OremarkList,CHARINDEX(',',@OremarkList)-1)
    SELECT @Oremark = @rt1
    SET @count2=LEFT(@Onum,CHARINDEX(',',@Onum)-1)
    SELECT @count2 =CAST(@count2 AS INT)
    IF( @Mflag != 2)
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
  ELSE IF(@nn <=@count1)
   BEGIN
                  SET @rt=SUBSTRING(@Mid,CHARINDEX(',',@Mid)+1,4000)
    SET @rt1=SUBSTRING(@OremarkList,CHARINDEX(',',@OremarkList)+1,4000)
    SET @rt2=SUBSTRING(@Onum,CHARINDEX(',',@Onum)+1,4000)
    WHILE(@i < (@nn - 1))
    BEGIN
      SET @rt = SUBSTRING(@rt,CHARINDEX(',',@rt)+1,4000)
     SET @rt1 = SUBSTRING(@rt1,CHARINDEX(',',@rt1)+1,4000)
     SET @rt2 = SUBSTRING(@rt2,CHARINDEX(',',@rt2)+1,4000)
     SET @i = @i + 1
    END
           SET @i = 1
    SET @rt = LEFT(@rt,CHARINDEX(',',@rt)-1)
    SET @rt1 = LEFT(@rt1,CHARINDEX(',',@rt1)-1)
    SET @count2 = LEFT(@rt2,CHARINDEX(',',@rt2)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SELECT @Oremark = @rt1
    SELECT @count2 = CAST(@count2 AS INT)
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
     SET @nn = @nn + 1
  END
 --返回个人第一次开单结果
 IF( @update_D_error = 0 AND @update_D_rowcount > 0 AND @insert_OI_error = 0 AND @insert0_OL_error = 0 )
 BEGIN
  COMMIT TRANSACTION   --开单成功
  SELECT 1 AS Result
 END
 ELSE
 BEGIN
  ROLLBACK TRANSACTION  --开单失败
  SELECT 0 AS Result
 END
 END    --(个人第一次开单END)
 ELSE IF( @FirstYN > 0)  --个人加菜
 BEGIN    --(个人加菜BEGIN)
 SELECT @Did1 = CAST(@Did AS INT)
 DECLARE @OrderInfo_flag INT     --判断是否套餐
 SELECT
  @OrderInfo_flag = Oflag
 FROM
  OrderInfo
 WHERE
  ( Did = @Did1 )
  AND( Ostatus = 0 )
 IF( @OrderInfo_flag = 0 ) --非套餐加菜
 BEGIN    --(个人非套餐加菜BEGIN)
  SELECT @OIid = OIid FROM OrderInfo
  WHERE
   ( Did = @Did1 )
   AND( Ostatus = 0 )
  SELECT @count1 = LEN(@Mid)-LEN(REPLACE(@Mid,',',''))+1
  SET @nn = 1
  SET @i = 1
  BEGIN TRANSACTION
  WHILE (@nn <= @count1)
  BEGIN
  SET @Mid = @Mid + ','
  SET @OremarkList = @OremarkList + ','
  SET @Onum = @Onum + ','
  IF(@nn = 1)
   BEGIN
    SET @rt=LEFT(@Mid,CHARINDEX(',',@Mid)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SET @rt1=LEFT(@OremarkList,CHARINDEX(',',@OremarkList)-1)
    SELECT @Oremark = @rt1
    SET @count2=LEFT(@Onum,CHARINDEX(',',@Onum)-1)
    SELECT @count2 =CAST(@count2 AS INT)
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark,Oflag)
       VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark,1)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
  ELSE IF(@nn <=@count1)
   BEGIN
 
                  SET @rt=SUBSTRING(@Mid,CHARINDEX(',',@Mid)+1,4000)
    SET @rt1=SUBSTRING(@OremarkList,CHARINDEX(',',@OremarkList)+1,4000)
    SET @rt2=SUBSTRING(@Onum,CHARINDEX(',',@Onum)+1,4000)
    WHILE(@i < (@nn - 1))
    BEGIN
      SET @rt = SUBSTRING(@rt,CHARINDEX(',',@rt)+1,4000)
     SET @rt1 = SUBSTRING(@rt1,CHARINDEX(',',@rt1)+1,4000)
     SET @rt2 = SUBSTRING(@rt2,CHARINDEX(',',@rt2)+1,4000)
     SET @i = @i + 1
    END
           SET @i = 1
    SET @rt = LEFT(@rt,CHARINDEX(',',@rt)-1)
    SET @rt1 = LEFT(@rt1,CHARINDEX(',',@rt1)-1)
    SET @count2 = LEFT(@rt2,CHARINDEX(',',@rt2)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SELECT @Oremark = @rt1
    SELECT @count2 = CAST(@count2 AS INT)
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark,Oflag)
       VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark,1)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
     SET @nn = @nn + 1
  END
 --返回加菜结果
 IF( @insert0_OL_error = 0 )
 BEGIN
  COMMIT TRANSACTION
  SELECT 1 AS Result
 END
 ELSE
 BEGIN
  ROLLBACK TRANSACTION
  SELECT 0 AS Result
 END
 END    --(个人非套餐加菜END)
 ELSE IF( @OrderInfo_flag = 1 ) --个人套餐加菜
 BEGIN    --(个人套餐加菜BEGIN)
  SELECT
   @OIid = OIid
  FROM
   OrderInfo
  WHERE
   ( Did = @Did1 )
   AND( Ostatus = 0 )
   AND( Oflag = 1 )
  SELECT @count1 = LEN(@Mid)-LEN(REPLACE(@Mid,',',''))+1
  SET @nn = 1
  SET @i = 1
  BEGIN TRANSACTION
  WHILE(@nn <= @count1)
  BEGIN --循环BEGIN
  SET @Mid = @Mid + ','
  SET @OremarkList = @OremarkList + ','
  SET @Onum = @Onum + ','
  IF(@nn = 1)
   BEGIN
    SET @rt=LEFT(@Mid,CHARINDEX(',',@Mid)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SET @rt1=LEFT(@OremarkList,CHARINDEX(',',@OremarkList)-1)
    SELECT @Oremark = @rt1
    SET @count2=LEFT(@Onum,CHARINDEX(',',@Onum)-1)
    SELECT @count2 =CAST(@count2 AS INT)
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark,Oflag)
       VALUES ( @OIid,@Mid1,@Mprice1,@Uid,@Oremark,1)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
  ELSE IF(@nn <=@count1)
   BEGIN
 
                  SET @rt=SUBSTRING(@Mid,CHARINDEX(',',@Mid)+1,4000)
    SET @rt1=SUBSTRING(@OremarkList,CHARINDEX(',',@OremarkList)+1,4000)
    SET @rt2=SUBSTRING(@Onum,CHARINDEX(',',@Onum)+1,4000)
    WHILE(@i < (@nn - 1))
    BEGIN
      SET @rt = SUBSTRING(@rt,CHARINDEX(',',@rt)+1,4000)
     SET @rt1 = SUBSTRING(@rt1,CHARINDEX(',',@rt1)+1,4000)
     SET @rt2 = SUBSTRING(@rt2,CHARINDEX(',',@rt2)+1,4000)
     SET @i = @i + 1
    END
    SET @i = 1
    SET @rt = LEFT(@rt,CHARINDEX(',',@rt)-1)
    SET @rt1 = LEFT(@rt1,CHARINDEX(',',@rt1)-1)
    SET @count2 = LEFT(@rt2,CHARINDEX(',',@rt2)-1)
    IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
    BEGIN
     SELECT @Mid1 = CAST( @rt AS INT )
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    ELSE    --如果@rt为菜单对应的拼音
    BEGIN
     SELECT @Mname1 = LOWER( @rt )
     SELECT @Mid1 = Mid FROM Menu
     WHERE Mname1 = @Mname1
     SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
     WHERE Mid = @Mid1
    END
    SELECT @Oremark = @rt1
    SELECT @count2 = CAST(@count2 AS INT)
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @count2 >=1 )
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark,Oflag)
       VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark,1)
      SELECT @insert0_OL_error = @@ERROR
      SET @count2 = @count2 - 1
     END
    END
    ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
       VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
     SELECT @insert0_OL_error = @@ERROR
    END
   END
     SET @nn = @nn + 1
  END--循环END
 IF( @insert0_OL_error = 0 )
 BEGIN
  COMMIT TRANSACTION
  SELECT 1 AS Result
 END
 ELSE
 BEGIN
  ROLLBACK TRANSACTION
  SELECT 0 AS Result
 END
 END   --(个人套餐加菜END)
 END   --(个人加菜END)
 END   --(个人开单END)
 ELSE IF ( @Nstatus = 1 )--团体开单  非套餐
 BEGIN   --(团体开单BEGIN)
  SET @ii = 1
  SELECT @count = LEN(@Did)-LEN(REPLACE(@Did,',',''))+1    --这里餐桌的个数，即 @count >= 2
  SET @mm = 1
  WHILE( @mm <= @count )
  BEGIN
  SET @Did = @Did + ','
  BEGIN TRANSACTION
  IF( @mm = 1 )
   BEGIN
    SET @dt=LEFT(@Did,CHARINDEX(',',@Did)-1)
    SELECT @Did1 = CAST( @dt AS INT )
    UPDATE
      DingingTable      --更新餐桌状态为"使用中"
    SET
     Dstatus = 3
    WHERE
     ( Did = @Did1 )
     AND( Dstatus IN(1,2) )
    SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
    SELECT @OrderInfoDid = @Did1
    EXECUTE procGetTimeID @timeID OUTPUT
    SELECT @Orid =N'P'+@timeID
    BEGIN     
     INSERT INTO OrderInfo( Orid,Did,Onum,Uid ) 
      VALUES( @Orid,@Did1,@Onume,@Uid )
     SELECT @insert_OI_error = @@ERROR
     SELECT @OIid = IDENT_CURRENT('OrderInfo')
     SELECT @count1 = LEN(@Mid)-LEN(REPLACE(@Mid,',',''))+1
     SET @nn = 1
     SET @i = 1
     WHILE(@nn <= @count1)
     BEGIN
      SET @Mid = @Mid + ','
      SET @OremarkList = @OremarkList + ','
      SET @Onum = @Onum + ','
     IF(@nn = 1)
      BEGIN
      SET @rt=LEFT(@Mid,CHARINDEX(',',@Mid)-1)
      IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
      BEGIN
       SELECT @Mid1 = CAST( @rt AS INT )
       SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
       WHERE Mid = @Mid1
      END
      ELSE    --如果@rt为菜单对应的拼音
      BEGIN
       SELECT @Mname1 = LOWER( @rt )
       SELECT @Mid1 = Mid FROM Menu
       WHERE Mname1 = @Mname1
       SELECT @Mflag= Mflag,@Mprice1 = Mprice FROM Menu
       WHERE Mid = @Mid1
      END
      SET @rt1=LEFT(@OremarkList,CHARINDEX(',',@OremarkList)-1)
      SELECT @Oremark = @rt1
      SET @count2=LEFT(@Onum,CHARINDEX(',',@Onum)-1)
      SELECT @count2 = CAST(@count2 AS INT)
      IF( @Mflag != 2 )
      BEGIN
       WHILE( @count2 >=1 )
        BEGIN
         INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
          VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
         SELECT @insert0_OL_error = @@ERROR
         SET @count2 = @count2 - 1
        END
      END
      ELSE
      BEGIN
       INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
         VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
       SELECT @insert0_OL_error = @@ERROR
      END
      END
     ELSE IF(@nn <=@count1)
      BEGIN
                    SET @rt=SUBSTRING(@Mid,CHARINDEX(',',@Mid)+1,4000)
      SET @rt1=SUBSTRING(@OremarkList,CHARINDEX(',',@OremarkList)+1,4000)
      SET @rt2=SUBSTRING(@Onum,CHARINDEX(',',@Onum)+1,4000)
      WHILE(@i < (@nn - 1))
       BEGIN
        SET @rt = SUBSTRING(@rt,CHARINDEX(',',@rt)+1,4000)
       SET @rt1 = SUBSTRING(@rt1,CHARINDEX(',',@rt1)+1,4000)
       SET @rt2 = SUBSTRING(@rt2,CHARINDEX(',',@rt2)+1,4000)
       SET @i = @i + 1
       END
              SET @i = 1
       SET @rt = LEFT(@rt,CHARINDEX(',',@rt)-1)
       SET @rt1 = LEFT(@rt1,CHARINDEX(',',@rt1)-1)
       SET @count2 = LEFT(@rt2,CHARINDEX(',',@rt2)-1)
       IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
       BEGIN
        SELECT @Mid1 = CAST( @rt AS INT )
        SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
        WHERE Mid = @Mid1
       END
       ELSE    --如果@rt为菜单对应的拼音
       BEGIN
        SELECT @Mname1 = LOWER( @rt )
        SELECT @Mid1 = Mid FROM Menu
        WHERE Mname1 = @Mname1
        SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
        WHERE Mid = @Mid1
       END
       SELECT @Oremark = @rt1
       SELECT @count2 = CAST(@count2 AS INT)
       IF( @Mflag != 2 )
       BEGIN
        WHILE( @count2 >=1 )
         BEGIN
          INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
           VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
          SELECT @insert0_OL_error = @@ERROR
          SET @count2 = @count2 - 1
         END
       END
       ELSE
       BEGIN
        INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
          VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
        SELECT @insert0_OL_error = @@ERROR
       END
      END
        SET @nn = @nn + 1
     END
    END
    END
  ELSE IF( @mm <= @count )
   BEGIN 
                  SET @dt=SUBSTRING(@Did,CHARINDEX(',',@Did)+1,4000)
    WHILE(@ii < (@mm - 1))
     BEGIN
      SET @dt = SUBSTRING(@dt,CHARINDEX(',',@dt)+1,4000)
     SET @ii = @ii + 1
     END
            SET @ii = 1
     SET @dt = LEFT(@dt,CHARINDEX(',',@dt)-1)
     SELECT @Did1 = CAST( @dt AS INT )
     UPDATE DingingTable SET Dstatus = 3 --更新餐桌状态为"使用中"
     WHERE
      ( Did = @Did1 )
       AND( Dstatus IN(1,2) )
     SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
     SELECT @Orid = Orid FROM OrderInfo
     WHERE
      ( Did = @OrderInfoDid )
      AND( Ostatus = 0 )
     BEGIN     
     INSERT INTO OrderInfo( Orid,Did,Onum,Uid ) 
      VALUES( @Orid,@Did1,@Onume,@Uid )
     SELECT @insert_OI_error = @@ERROR
     SELECT @OIid = IDENT_CURRENT('OrderInfo')
     SELECT @count1 = LEN(@Mid)-LEN(REPLACE(@Mid,',',''))+1
     SET @nn = 1
     SET @i = 1
     WHILE (@nn <= @count1)
     BEGIN
     SET @Mid = @Mid + ','
     SET @OremarkList = @OremarkList + ','
     SET @Onum = @Onum + ','
     IF(@nn = 1)
      BEGIN
      SET @rt=LEFT(@Mid,CHARINDEX(',',@Mid)-1)
      IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
      BEGIN
       SELECT @Mid1 = CAST( @rt AS INT )
       SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
       WHERE Mid = @Mid1
      END
      ELSE    --如果@rt为菜单对应的拼音
      BEGIN
       SELECT @Mname1 = LOWER( @rt )
       SELECT @Mid1 = Mid FROM Menu
       WHERE Mname1 = @Mname1
       SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
       WHERE Mid = @Mid1
      END
      SET @rt1=LEFT(@OremarkList,CHARINDEX(',',@OremarkList)-1)
      SELECT @Oremark = @rt1
      SET @count2=LEFT(@Onum,CHARINDEX(',',@Onum)-1)
      SELECT @count2 = CAST(@count2 AS INT)
      IF( @Mflag != 2 )
      BEGIN
       WHILE( @count2 >=1 )
        BEGIN
         INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
          VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
         SELECT @insert0_OL_error = @@ERROR
         SET @count2 = @count2 - 1
        END
      END
      ELSE
       BEGIN
        INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
          VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
        SELECT @insert0_OL_error = @@ERROR
       END
      END
     ELSE IF(@nn <=@count1)
      BEGIN
                    SET @rt=SUBSTRING(@Mid,CHARINDEX(',',@Mid)+1,4000)
      SET @rt1=SUBSTRING(@OremarkList,CHARINDEX(',',@OremarkList)+1,4000)
      SET @rt2=SUBSTRING(@Onum,CHARINDEX(',',@Onum)+1,4000)
      WHILE(@i < (@nn - 1))
       BEGIN
        SET @rt = SUBSTRING(@rt,CHARINDEX(',',@rt)+1,4000)
       SET @rt1 = SUBSTRING(@rt1,CHARINDEX(',',@rt1)+1,4000)
       SET @rt2 = SUBSTRING(@rt2,CHARINDEX(',',@rt2)+1,4000)
       SET @i = @i + 1
       END
              SET @i = 1
       SET @rt = LEFT(@rt,CHARINDEX(',',@rt)-1)
       SET @rt1 = LEFT(@rt1,CHARINDEX(',',@rt1)-1)
       SET @count2 = LEFT(@rt2,CHARINDEX(',',@rt2)-1)
       IF( ISNUMERIC( @rt ) = 1 ) --如果@rt为菜单编号
       BEGIN
        SELECT @Mid1 = CAST( @rt AS INT )
        SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
        WHERE Mid = @Mid1
       END
       ELSE    --如果@rt为菜单对应的拼音
       BEGIN
        SELECT @Mname1 = LOWER( @rt )
        SELECT @Mid1 = Mid FROM Menu
        WHERE Mname1 = @Mname1
        SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
        WHERE Mid = @Mid1
       END
       SELECT @Oremark = @rt1
       SELECT @count2 = CAST(@count2 AS INT)
       IF( @Mflag != 2 )
       BEGIN
        WHILE( @count2 >=1 )
         BEGIN
          INSERT INTO OrderList( OIid,Mid,Mprice,Uid,Oremark)
           VALUES( @OIid,@Mid1,@Mprice1,@Uid,@Oremark)
          SELECT @insert0_OL_error = @@ERROR
          SET @count2 = @count2 - 1
         END
       END
       ELSE
        BEGIN
         INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid,Oremark)
           VALUES( @OIid,@Mid1,@Mprice1,@count2,@Uid,@Oremark)
         SELECT @insert0_OL_error = @@ERROR
        END
      END
        SET @nn = @nn + 1
     END
    END
   END
  SET @mm = @mm + 1
  IF(@update_D_error = 0 AND @update_D_rowcount > 0 AND @insert_OI_error = 0 AND @insert0_OL_error =0)
   BEGIN
    COMMIT TRANSACTION
    SELECT 1 AS Result
   END
   ELSE
   BEGIN
    ROLLBACK TRANSACTION
    SELECT 0 AS Result
   END
  END  --循环END
 END   --(团体开单END)
 END   --(非套餐END)
 ELSE IF(@Oflag = 1)  --套餐
 BEGIN   --(套餐BEGIN)
 IF(@Nstatus = 0) --个人开单
 BEGIN   --(个人开单BEGIN)
  EXECUTE procGetTimeID @timeID OUTPUT
  SELECT @Orid =N'T'+@timeID
  SELECT @Did1 = CAST(@Did AS INT)
  --修改餐桌状态为"使用中"
  BEGIN TRANSACTION
  UPDATE DingingTable SET Dstatus = 3
  WHERE
    ( Did = @Did1 )
   AND( Dstatus IN(1,2))
  SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
  SELECT @BLid = CAST(@Mid AS INT)
  INSERT INTO OrderInfo( Orid,Did,Onum,BLid,Uid,Oflag ) 
   VALUES( @Orid,@Did1,@Onume,@BLid,@Uid,1 )
  SELECT @insert_OI_error = @@ERROR
  SELECT @OIid = IDENT_CURRENT('OrderInfo')
  --以下向OrderList表中插入数据
  DECLARE @Bnum INT   --循环相同菜的个数
  DECLARE @BLid_Mid INT --保存取出的菜单号
  DECLARE Fetch_BLid_Mid CURSOR FOR
  SELECT Mid FROM BundlingMenu
  WHERE BLid = @BLid
 
  OPEN Fetch_BLid_Mid
  FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid
  WHILE(@@FETCH_STATUS = 0)
  BEGIN--取游标BEGIN
   SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
   WHERE Mid = @BLid_Mid
   SELECT
    @Bnum = Bnum
   FROM
    BundlingMenu
   WHERE
    ( Mid = @BLid_Mid )
    AND( BLid = @BLid )
   IF( @Mflag != 2 )
   BEGIN
    WHILE( @Bnum >= 1 )
    BEGIN
     INSERT INTO OrderList(OIid,Mid,Mprice,Uid)
      VALUES(@OIid,@BLid_Mid,@Mprice1,@Uid)
     SELECT @insert0_OL_error = @@ERROR
     SET @Bnum = @Bnum - 1
    END
   END
   ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid)
      VALUES( @OIid,@BLid_Mid,@Mprice1,@Bnum,@Uid)
     SELECT @insert0_OL_error = @@ERROR
    END
   FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid
  END--取游标END
  CLOSE Fetch_BLid_Mid 
  DEALLOCATE Fetch_BLid_Mid
 IF( @update_D_error = 0 AND @update_D_rowcount > 0 AND @insert_OI_error = 0 AND @insert0_OL_error = 0 )
  BEGIN
   COMMIT TRANSACTION
   SELECT 1 AS Result
  END
 ELSE
  BEGIN
   ROLLBACK TRANSACTION
   SELECT 0 AS Result
  END
 END   --(个人开单END)
 ELSE IF(@Nstatus = 1) --团体套餐开单
 BEGIN   --(团体套餐开单BEGIN)
  SET @ii = 1
  SELECT @count = LEN(@Did)-LEN(REPLACE(@Did,',',''))+1    --这里餐桌的个数，即 @count >= 2
  SET @mm = 1
  WHILE( @mm <= @count )
  BEGIN  --循环BEGIN
  SET @Did = @Did + ','
  BEGIN TRANSACTION
  IF( @mm = 1 )
  BEGIN   --(@mm=1BEGIN)
   SET @dt=LEFT(@Did,CHARINDEX(',',@Did)-1)
   EXECUTE procGetTimeID @timeID OUTPUT
   SELECT @Orid =N'T'+@timeID
   SELECT @Did1 = CAST(@dt AS INT)
   SELECT @OrderInfoDid = @Did1
   --修改餐桌状态为"使用中"
   UPDATE DingingTable SET Dstatus = 3
   WHERE
     ( Did = @Did1 )
    AND( Dstatus IN(1,2) )
   SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
   SELECT @BLid = CAST(@Mid AS INT)
   INSERT INTO OrderInfo( Orid,Did,Onum,BLid,Uid,Oflag ) 
    VALUES( @Orid,@Did1,@Onume,@BLid,@Uid,1 )
   SELECT @insert_OI_error = @@ERROR
   SELECT @OIid = IDENT_CURRENT('OrderInfo')
   --以下向OrderList表中插入数据
   DECLARE @Bnum1 INT   --循环相同菜的个数
   DECLARE @BLid_Mid1 INT --保存取出的菜单号
   DECLARE Fetch_BLid_Mid CURSOR FOR
   SELECT Mid FROM BundlingMenu
   WHERE BLid = @BLid
   OPEN Fetch_BLid_Mid
   FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid1
   WHILE(@@FETCH_STATUS = 0)
   BEGIN--取游标BEGIN
   SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
   WHERE Mid = @BLid_Mid1
   SELECT 
    @Bnum1 = Bnum
   FROM
    BundlingMenu
   WHERE
    ( Mid = @BLid_Mid1 )
    AND( BLid = @BLid )
   IF( @Mflag != 2 )
   BEGIN
    WHILE( @Bnum1 >= 1 )
    BEGIN
     INSERT INTO OrderList(OIid,Mid,Mprice,Uid)
      VALUES(@OIid,@BLid_Mid1,@Mprice1,@Uid)
     SELECT @insert0_OL_error = @@ERROR
     SET @Bnum1 = @Bnum1 - 1
    END
   END
   ELSE
    BEGIN
     INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid)
      VALUES( @OIid,@BLid_Mid1,@Mprice1,@Bnum1,@Uid)
     SELECT @insert0_OL_error = @@ERROR
    END
   FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid1
   END--取游标END
   CLOSE Fetch_BLid_Mid 
   DEALLOCATE Fetch_BLid_Mid
  END --(@mm=1END)
  ELSE IF( @mm <= @count )
  BEGIN--(@mm <= @count BEGIN)
   SET @dt=SUBSTRING(@Did,CHARINDEX(',',@Did)+1,4000)
   WHILE(@ii < (@mm - 1))
   BEGIN
     SET @dt = SUBSTRING(@dt,CHARINDEX(',',@dt)+1,4000)
    SET @ii = @ii + 1
   END
          SET @ii = 1
   SET @dt = LEFT(@dt,CHARINDEX(',',@dt)-1)
   SELECT @Did1 = CAST( @dt AS INT )
   UPDATE
     DingingTable  --更新餐桌状态为"使用中"
   SET
    Dstatus = 3
   WHERE
    ( Did = @Did1 )
     AND( Dstatus IN(1,2) )
   SELECT @update_D_error = @@ERROR,@update_D_rowcount = @@ROWCOUNT
   SELECT
    @Orid = Orid
   FROM
     OrderInfo
   WHERE
    ( Did = @OrderInfoDid )
    AND( Ostatus = 0 )
   SELECT @BLid = CAST(@Mid AS INT)
   INSERT INTO OrderInfo( Orid,Did,Onum,BLid,Uid,Oflag ) 
    VALUES( @Orid,@Did1,@Onume,@BLid,@Uid,1 )
   SELECT @insert_OI_error = @@ERROR
   SELECT @OIid = IDENT_CURRENT('OrderInfo')
   --以下向OrderList表中插入数据
   DECLARE @Bnum2 INT   --循环相同菜的个数
   DECLARE @BLid_Mid2 INT --保存取出的菜单号
   DECLARE Fetch_BLid_Mid CURSOR FOR
   SELECT Mid FROM BundlingMenu
   WHERE BLid = @BLid
   OPEN Fetch_BLid_Mid
   FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid2
   WHILE(@@FETCH_STATUS = 0)
   BEGIN--取游标BEGIN
    SELECT @Mflag = Mflag,@Mprice1 = Mprice FROM Menu
    WHERE Mid = @BLid_Mid2
    SELECT
     @Bnum2 = Bnum
    FROM
     BundlingMenu
    WHERE
     ( Mid = @BLid_Mid2 )
     AND( BLid = @BLid )
    IF( @Mflag != 2 )
    BEGIN
     WHILE( @Bnum2 >= 1 )
     BEGIN
      INSERT INTO OrderList(OIid,Mid,Mprice,Uid)
       VALUES(@OIid,@BLid_Mid2,@Mprice1,@Uid)
      SELECT @insert0_OL_error = @@ERROR
      SET @Bnum2 = @Bnum2 - 1
     END
    END
    ELSE
     BEGIN
      INSERT INTO OrderList( OIid,Mid,Mprice,Oratio,Uid)
       VALUES( @OIid,@BLid_Mid2,@Mprice1,@Bnum2,@Uid)
      SELECT @insert0_OL_error = @@ERROR
     END
    FETCH NEXT FROM Fetch_BLid_Mid INTO @BLid_Mid2
   END--取游标END
   CLOSE Fetch_BLid_Mid 
   DEALLOCATE Fetch_BLid_Mid
  END--(@mm <= @count END)
 SET @mm = @mm + 1
 IF( @update_D_error = 0 AND @update_D_rowcount > 0 AND @insert_OI_error = 0 AND @insert0_OL_error = 0 )
  BEGIN
   COMMIT TRANSACTION
   SELECT 1 AS Result
  END
 ELSE
  BEGIN
   ROLLBACK TRANSACTION
   SELECT 0 AS Result
  END
 END--(循环END)
 END--(团体套餐开单END)
 END--(套餐END)
END
GO

--EXECUTE procInsertOrderInfoOrderList '56,57','1004,1005','1,1','7','1003','不,'0','1' 

2、动态SQL

F EXISTS(SELECT NAME FROM sysobjects
        WHERE NAME = N'procSelectAccountedInfoByDate' AND Type = N'P')
DROP PROCEDURE procSelectAccountedInfoByDate
GO

CREATE PROCEDURE procSelectAccountedInfoByDate
   (
 @Date NVARCHAR(10)
   )
AS
BEGIN
 CREATE TABLE #Temp_001
 (
  Pid INT,
  Pname NVARCHAR(20),
  Uname NVARCHAR(20),
  Atotal2 MONEY
 )
 INSERT INTO #Temp_001(Pid,Pname,Uname,Atotal2)
 (
  SELECT 
   P.Pid AS Pid,
   P.Pname AS Pname,
   ISNULL(DBO.funGetUnameByUid(A.Uid),'') AS Uname,
   A.Atotal2 AS Atotal2
  FROM
   Paymode AS P LEFT JOIN Account AS A ON ( P.Pid = A.Pid ) AND ( DBO.funGetNewDate(A.Atime) = @Date )
 )
 DECLARE @SQL VARCHAR(8000)
 SET @SQL = 'SELECT
    Pid AS 代码,
    Pname AS 科目名称'
 SELECT
  @SQL = @SQL + ','+Users.Uname+'=CONVERT(NVARCHAR,ISNULL(SUM(CASE Uname WHEN '''+Users.Uname+''' THEN Atotal2 END ),NULL),102)'
 FROM
  Users
 WHERE
  Tid = 7  --属于收银
 ORDER BY Uid
 SET
  @SQL = @SQL + ',CONVERT(NVARCHAR,ISNULL(SUM(Atotal2),NULL),102) AS 合计金额
 FROM #Temp_001
 GROUP BY Pid,Pname
 ORDER BY Pid'
 PRINT @SQL
 EXECUTE (@SQL)
 DROP TABLE #Temp_001
END
GO

toddzst
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
sql存储过程几个简单例子
09-10
SQL存储过程是数据库管理系统中的一种重要功能，它允许用户预先定义并存储一系列的SQL语句，以便后续重复使用或执行复杂的业务逻辑。在SQL Server中，存储过程是由Transact-SQL（T-SQL）语言编写的，经过编译后存储...
sql存储过程
02-27
sql存储过程简单介绍，学习。1234567896541232145664477
mysql创建使用存储过程
i_mycode的博客
10-28 3565
mysql存储过程详解 1.      存储过程简介   我们常用的操作数据库语言SQL语句在执行的时候需要要先编译，然后执行，...
MySQL 实验二语言基础编程 创建存储过程 综合编程题目
zinc1234596的博客
03-28 1752
题目一： 使用 MySQL Workbench 或者其他的图形化工具，创建存储过程，计算出 1500 以内能被 9 整除的整数的个数。把操作结果和操作过程截屏，填写到实验报告中。 delimiter // create procedure topic1(out num int) BEGIN declare i int default 0; set num=0; while i<1500 do-- 循环开始 set i=i+1; if mod(i,9)=0 THEN set num=num
一个sql的优化：判断表行数大于0行
haiross的专栏
11-03 1万+
判断表行数大于0行的逻辑改写   判断表行数大于0行的逻辑改写 内容来自梁敬彬的基于案例学SQL优化，正文如下： 需求看透，什么才是真正的需求。 begin select count(*) into v_cnt from t1 ; if v_cnt>0 then  …A逻辑…. else then  …B逻辑….. End;   我来翻译
SQL 存储过程
最新发布
paoe1612205661的博客
10-12 2万+
SQL 存储过程的学习
sql 存储过程
树叶子的博客
11-11 4638
目录 一、存储过程概念 二、存储过程的创建 三. 修改和删除存储过程 四、存储过程的种类 一、存储过程概念 1.概念 存储过程是存放在数据库服务器上的预先定义与编译好的T-SQL语句集合，是一个独立的数据库对象。 2.特点 实现了模块化编程。 存储过程具有对数据库立即访问的功能。 使用存储过程可以加快程序的运行速度。 使用存储过程可以减少网络流量。 使用存储过程可以提高数据库的安...
SQL存储过程详解
WL456258的博客
03-02 1万+
存储过程解答
SQL 存储过程 调试
风起未来
04-20 7730
SQL 存储过程 调试SqlServer输出 print @变量名   print  @NextCount    print  '输出常量'在需要的位置写上，然后执行下述操作，执行一遍，对该存储过程进行保存然后选择需要执行的存储过程，填写对应的参数，点击确定执行；执行后会出现下述图片，点击 消息 查看自己的print输出结果；...
C# winform调用SQL存储过程-菜鸟入门 详细注释
08-05
内容概要：简单的C# winform调用存储过程实例，创建存储过程入参，通过SqlConnection对象和SqlCommand对象调用存储过程，获取存储过程的出参并显示出来，详细代码注释，希望对用到C#调用存储过程的小伙伴有帮助 ...
executesql 存储过程
09-11
在SQL Server中，`EXECUTE SQL` 和 `sp_executesql` 是用于执行动态SQL语句的两个关键存储过程。这两个方法在处理不确定或需要在运行时构建的SQL语句时非常有用。以下是对这两个概念的详细解释： 1. **EXECUTE SQL*...
sql存储过程详解
09-10
SQL存储过程是数据库管理系统中预编译的SQL语句集合，它封装了一系列的数据库操作，可以提高数据库操作的效率和安全性。在本文中，我们将深入探讨四种不同类型的存储过程：不带参数、带输入参数、带输入和输出参数...
SQL存储过程使用介绍
热门推荐
EnskDeCode
04-25 15万+
在数据库编程过程中经常会用到存储过程 , 相比 SQL 语句 , 存储过程更方便 , 快速 , 安全 ; 先将存储过程的相关介绍和使用方法总结如下 ;1. 存储过程的概念存储过程 (Stored Procedure) 是在大型数据库系统中 , 一组为了完成特定功能的 SQL 语句集 , 存储在数据库中 , 经过第一次编译后再次调用不需要再次编译 , 用户通过指定存储过程的名字并给出参数 (如果该存储
SQL存储过程与函数
m0_56223907的博客
08-05 2843
1. 存储过程概述 2. 创建存储过程 3. 调用存储过程 4.存储函数的使用 5. 存储过程和函数的查看、修改、删除 6. 关于存储过程使用的争议
SQL存储过程详解与应用
"SQL存储过程是数据库管理中的一种重要工具，用于封装一组SQL语句和流程控制结构，以实现特定的功能。它们在大型数据库系统中扮演着关键角色，因为它们可以提高性能、增强安全性并简化复杂的操作。存储过程分为系统...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值