SELECT a.*
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a where a.au_lname='bennet'
或SELECT a.*
FROM OPENROWSET('SQLOLEDB','jiangbing';'sa';'',
'SELECT * FROM pubs.dbo.authors where au_lname=''bennet'' ORDER BY au_lname, au_fname') AS a推荐后者
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a where a.au_lname='bennet'
或SELECT a.*
FROM OPENROWSET('SQLOLEDB','jiangbing';'sa';'',
'SELECT * FROM pubs.dbo.authors where au_lname=''bennet'' ORDER BY au_lname, au_fname') AS a推荐后者
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors where au_lname=%s ORDER BY au_lname, au_fname') AS a",m_temp);