DECLARE @var1 varchar(255)
SELECT @var1 =SELECT top 1 loginuser FROM school order by logintime
select @var1= 'SELECT a.* FROM OPENROWSET(''SQLOLEDB'',''218.58.143.72'';''sa'';''good'', ''SELECT * FROM pubs.dbo.authors where au_fname=' + @var1 + ''') AS a '
exec (@var1)
SELECT @var1 =SELECT top 1 loginuser FROM school order by logintime
select @var1= 'SELECT a.* FROM OPENROWSET(''SQLOLEDB'',''218.58.143.72'';''sa'';''good'', ''SELECT * FROM pubs.dbo.authors where au_fname=' + @var1 + ''') AS a '
exec (@var1)
DECLARE @var1 varchar(255)
SELECT top 1 @var1=loginuser FROM school order by logintime
select @var1= 'SELECT a.* FROM OPENROWSET(''SQLOLEDB'',''218.58.143.72'';''sa'';''good'', ''SELECT * FROM pubs.dbo.authors where au_fname=''''' + @var1 + ''''''') AS a '
exec (@var1)