Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE
declare @name varchar(30)
declare @sqlText varchar(500)
set @name='汤'
set @sqlText='select * from v_matr_stu where realname='''''+@name+''''
exec('select * from openquery(ORCL,'''+@sqlText+''''')')
用OpenQuery 性能有很大的提升
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13571112/viewspace-615350/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13571112/viewspace-615350/