如何在存储过程中使用两个数据库并获得返回
问题描述:
在存储过程下面发布
首先,我试图在客户端数据库中找到记录,如果没有找到那么
在主数据库中搜索它。
在ASP应用程序中使用存储过程。
请帮助获取没有任何输出参数的返回值
ALTER PROCEDURE [dbo].[app_AuthenticateEmailCount]
@Email varchar(50)
AS
BEGIN
DECLARE @TotalCRecords varchar(10);
DECLARE @TotalMRecords varchar(10)
set @TotalCRecords = 'SELECT COUNT(*) AS TotalCRecords FROM ff_fvdcbdev.dbo.app_User cu inner join ff_fvdcbdev.dbo.app_Person cp on cu.idUser = cp.idUser
WHERE cp.emailAddress =' + @Email
IF (@TotalCRecords = '0')
set @TotalMRecords = 'SELECT COUNT(*) AS TotalMRecords FROM freefunds.dbo.app_User mu inner join freefunds.dbo.app_Person mp on mu.idUser = mp.idUser
WHERE mp.emailAddress =' + @Email
答
尝试UNION
:
TryUNION
:
SELECT 'CRecords' as [Type], COUNT(*) AS [Count] FROM ff_fvdcbdev.dbo.app_User cu inner join ff_fvdcbdev.dbo.app_Person cp on cu.idUser = cp.idUser
WHERE cp.emailAddress = @Email
UNION
SELECT 'MRecords' as [Type], COUNT(*) AS [Count] FROM freefunds.dbo.app_User mu inner join freefunds.dbo.app_Person mp on mu.idUser = mp.idUser
WHERE mp.emailAddress = @Email