Database

DECLARE @variableProc1 varchar(100)<br />
SET @variableProc1 = 'Val 1';<br />
EXECUTE('DECLARE @variableExec1 varchar(100); SET @variableExec1 = ''In variableExec1''; Print @variableExec1; ')<br />
--EXECUTE('DECLARE @variableExec2 varchar(100); SET @variableExec2 = ''In variableExec2'';')<br />
--SET  @variableProc1 = variableExec2;<br />
PRINT @variableProc1;

Table                ID                    Name
db1.Department       1                     Dept1   
db2.Department       1                     Dept2          
db3.Department       1                     Dept3
db4.Department       1                     Dept4

declare @n int	
declare @Name nvarchar(256)
set @n = 1
while (@n < 5)
begin	
	if (@n = 1) use db1
	else if (@n = 2) use db2
	else if (@n = 3) use db3
	else if (@n = 4) use db4

	select [Name] from Department where [ID] = 1
	set @Name = [Name] from dbo.Department where [ID] = 1
	print @Name

	set @n = @n + 1
end 

rs2.MoveFirst<br />
rs2.Find("MbrId = "+updLogin)

ORA-01427: single-row subquery returns more than one row

So a table with 3 rows in it and the column that I'm querying has as data
ROWA
ROWB
ROWC
would return the string "ROWA,ROWB,ROWC".