IF EXISTS(SELECT name
FROM sysobjects
WHERE name = N'testtable'
AND type = 'U')
DROP TABLE testtable
GO
if exists(SELECT *
FROM OPENROWSET('SQLOLEDB',
'DRIVER={SQL Server};SERVER=server;UID=sa;PWD=',
'exec ft_xs..bbb') AS a)
begin
SELECT * into testtable
FROM OPENROWSET('SQLOLEDB',
'DRIVER={SQL Server};SERVER=server;UID=sa;PWD=',
'exec ft_xs..bbb') AS a