数据库中已存在名为 'global_temp_tb' 的对象。??????????????????

[shankaipingo]

/******************************************************************************
**
** 得到该用户所管辖的所有人员的globalID
**
*******************************************************************************/
ALTER PROCEDURE dbo.sp_GetReminders
@username NVarChar(30) -- 用户名称
AS



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[global_temp_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[global_temp_tb]





/******************************************************************************
**
** 当该用户是直属于区的情况下,得到该用户所管辖的所有人员
**
*******************************************************************************/

IF EXISTS (SELECT *
FROM global_user_position_tb
WHERE global_user_position_tb.streetid = - 1 AND global_user_position_tb.username = @username)
begin

SELECT globalid
INTO global_temp_tb from(
SELECT GlobalId
FROM basicinfo_tb ) A




END


/******************************************************************************
**
** 当该用户是直属于街道的情况下,得到该用户所管辖的所有人员
**
*******************************************************************************/


IF EXISTS
(SELECT *
FROM global_user_position_tb
WHERE global_user_position_tb.communityid = - 1 AND streetid <> - 1 AND global_user_position_tb.username = @username)
BEGIN

SELECT globalid
INTO global_temp_tb from(
SELECT basicinfo_tb.globalid
FROM basicinfo_tb, global_user_position_tb
WHERE basicinfo_tb.street = global_user_position_tb.streetid AND
global_user_position_tb.username = @username) B

END



/******************************************************************************
**
** 当用户是直属于社区的情况下,得到该用户所管辖的所有人员
**
*******************************************************************************/




IF EXISTS
(SELECT username, districtId, streetId, communityId
FROM global_user_position_tb
WHERE (communityId <> - 1) AND (streetId <> - 1) AND (username = @username))
begin


SELECT GlobalId
INTO global_temp_tb
FROM (SELECT basicinfo_tb.GlobalId
FROM basicinfo_tb INNER JOIN
global_user_position_tb ON basicinfo_tb.community = global_user_position_tb.communityid AND basicinfo_tb.street = global_user_position_tb.streetId AND global_user_position_tb.username = @username) C

end


/******************************************************************************
**
** 根据权限和globalid进行筛选
**
*******************************************************************************/
SELECT global_remainder_tb.functionId, global_remainder_tb.globalid, global_remainder_tb.num, global_remainder_tb.pagename,
global_remainder_tb.pagepath, global_remainder_tb.content
FROM global_remainder_tb INNER JOIN
global_temp_tb ON global_remainder_tb.globalid = global_temp_tb.GlobalId
WHERE (global_remainder_tb.functionId IN
(SELECT global_role_function_tb.functionid
FROM aspnet_Users INNER JOIN
aspnet_Roles INNER JOIN
global_role_function_tb ON aspnet_Roles.RoleName = global_role_function_tb.rolename INNER JOIN
aspnet_UsersInRoles ON aspnet_Roles.RoleId = aspnet_UsersInRoles.RoleId ON
aspnet_Users.UserId = aspnet_UsersInRoles.UserId
WHERE (aspnet_Users.UserName = @username)))



drop table global_temp_tb




我不是已经删除了global_temp_tb了吗？


为什么还出错说

数据库中已存在名为 'global_temp_tb' 的对象。

[shankaipingo]

HELP

[huangkc]

SQL中有两处
SELECT GlobalId
INTO global_temp_tb

所以才提示这个问题，你得修改一下

[shankaipingo]

事实上SQL中有三处
SELECT GlobalId
INTO global_temp_tb
用户是不能出现在三种情况中的。只可能出现一种情况，
所以在一次执行过程中，是不可能执行两次或以上的这个语句。

这里绝对不是问题