create PROCEDURE dbo.StoredProcedure1
@username NVarChar(30) -- 用户名称
ASIF EXISTS (SELECT *
FROM global_user_position_tb
WHERE global_user_position_tb.streetid = - 1 AND global_user_position_tb.username = @username)
begin
SELECT GlobalId
FROM basicinfo_tb
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 basicinfo_tb.globalid
FROM basicinfo_tb, global_user_position_tb
WHERE basicinfo_tb.street = global_user_position_tb.streetid
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 basicinfo_tb.globalid
FROM basicinfo_tb, global_user_position_tb
WHERE basicinfo_tb.street = global_user_position_tb.streetid AND
basicinfo_tb.community = global_user_position_tb.communityid
END
而且如果合并上述三个情况产生的结果表啊
@username NVarChar(30) -- 用户名称
ASIF EXISTS (SELECT *
FROM global_user_position_tb
WHERE global_user_position_tb.streetid = - 1 AND global_user_position_tb.username = @username)
begin
SELECT GlobalId
FROM basicinfo_tb
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 basicinfo_tb.globalid
FROM basicinfo_tb, global_user_position_tb
WHERE basicinfo_tb.street = global_user_position_tb.streetid
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 basicinfo_tb.globalid
FROM basicinfo_tb, global_user_position_tb
WHERE basicinfo_tb.street = global_user_position_tb.streetid AND
basicinfo_tb.community = global_user_position_tb.communityid
END
而且如果合并上述三个情况产生的结果表啊
--第一种方法:直接用存储过程返回的数据集select * from openrowset('sqloledb','Trusted_Connection=yes','exec 数据库名.dbo.存储过程名') select * from openrowset('sqloledb','Trusted_Connection=yes','exec 数据库名..存储过程名') select * from openrowset('sqloledb','localhost';'用户名';'密码','exec 数据库名..存储过程名')select * from openrowset('sqloledb','192.168.0.1';'用户名';'密码','exec 数据库名..存储过程名')-第二种方法:先创建临时表,然后再追加create table #t(...)insert into #t exec 存储过程名select * from #t