sql 语句可以和存储过程一样的写

1、
DECLARE @OrderCon varchar(300), @OrderCons varchar(600), @Orderstr varchar(650)
              SET @OrderCons = '' DECLARE MyCursor CURSOR FOR
                (SELECT OrderCon
                FROM TBL_OrderConfirm
                WHERE IsConfirmed = 0)
                      
                OPEN MyCursor
                FETCH Next FROM MyCursor  INTO @OrderCon
              While(@@Fetch_Status = 0)
              BEGIN
               IF (@OrderCons != '')
               Begin
                SET @OrderCons = @OrderCons + 'OR'
               End
               SET @OrderCons =  @OrderCons + @OrderCon
               FETCH Next FROM MyCursor INTO @OrderCon
              END
              CLOSE myCursor DEALLOCATE myCursor
              SET @Orderstr = ('SELECT COUNT(*) AS A_Count
                  FROM Tbl_order
                  WHERE Isdelete = 0 AND IsConfirmed = 1 AND IsPrint = 0 AND
                  OrderNo IS NOT NULL AND DeliveryWay = 1 AND ('+ @OrderCons + ')')
              EXEC (@Orderstr)
2、
由于新旧系统问题，需要把数据库内容进行修改，下面说说详细情况：
有一个字段 bianhao(varchar(20)),原来的数据有类似如下几个数据：
1010001
1010002
1020001
2010001
2020001
-------------------------
我们需要做如下修改：
1、前面的第一个字符 '1' 改为'A', '2' 改为'B', '3' 改为'C', 然后就是依次类推；
2、中间的'01' 改为'2001', '02' 改为'2002, '03' 改为'2003', 然后就是依次类推；
3、后面的'0001' 改为'00001', '0002' 改为'00002', '0003' 改为'00003',也就是多了一位。

Unames = char(ascii(left(Unames,1))+16) + '20' + substring(Unames,2,2) + '0' + right(Unames,3)