USE [YunNanHw]
GO
/****** Object: StoredProcedure [dbo].[EventReport] Script Date: 06/07/2018 08:47:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[EventReport]
(
@cusID nvarchar(50),
@adminid nvarchar(50)
)
as
begin
declare @departID nvarchar(50);
declare @departname nvarchar(50);
declare @ChaoQi int;
declare @ShangBao int;
declare @WanCheng int;
declare @ChuLi int;
declare @SOS int;
declare @retention int;
declare @electricity int;
declare @Transboundary int;
declare @str nvarchar(max);
select @str=dbo.SQLDataPowerFilter(@adminid)
----正确的临时表删除操作
if object_id('tempdb..#aa') is not null Begin
drop table #aa
drop table #tt
End
CREATE TABLE #tt(
[DepartID] [nvarchar](50) NOT NULL,
[DepartName] [nvarchar](200) NOT NULL,
[ChaoQi] [int] NULL,
[ShangBao] [int] NULL,
[WanCheng] [int] NULL,
[Ch
存储过程带有参数返回值和游标的
最新推荐文章于 2024-06-09 20:30:54 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)