L�m th? n�o �? v�?t qua m?t bi?n v?i m?t truy v?n m�y ch? ��?c li�n k?t

ID c?a b�i: 314520 - Xem s?n ph?m m� b�i n�y �p d?ng v�o.

Th�ng b�o: b�i vi?t n�y l� b�i ��?c d?ch b?i M�y d?ch

Nh?p chu?t v�o ��y �? hi?n th? b?n g?c Ti?ng anh v� b?n d?ch m�y theo ch? �? so s�nh.

Bung t?t c? | Thu g?n t?t c?

B�i vi?t n�y m� t? c�ch �? v�?t qua m?t bi?n v?i m?t truy v?n m�y ch? ��?c li�n k?t.

Khi b?n truy v?n m?t m�y ch? ��?c li�n k?t, b?n th�?ng xuy�n th?c hi?n m?t truy v?n pass-through s? d?ng OPENQUERY, OPENROWSET ho?c OPENDATASOURCE tuy�n b?. B?n c� th? xem c�c v� d? trong SQL Server s�ch m?ng �? xem l�m th? n�o �? l�m �i?u n�y b?ng c�ch s? d?ng ��?c x�c �?nh tr�?c Transact-SQL strings, nh�ng kh�ng c� kh�ng c� v� d? v? l�m th? n�o �? v�?t qua m?t bi?n v?i c�c ch?c n�ng n�y. B�i vi?t n�y cung c?p ba v� d? v? l�m th? n�o �? v�?t qua m?t bi?n v?i m?t truy v?n m�y ch? ��?c li�n k?t.

�? v�?t qua m?t bi?n v?i m?t trong c�c ch?c n�ng pass-through, b?n ph?i x�y d?ng m?t truy v?n n�ng �?ng.

B?t k? d? li?u n�o bao g?m c�c b�o gi� nhu c?u c? th? x? l?. �? bi?t th�m chi ti?t, xem ch? �? "s? d?ng char v� varchar d? li?u" trong SQL Server s�ch tr?c tuy?n v� xem b�i vi?t sau trong c� s? ki?n th?c Microsoft:

156501

(http://support.microsoft.com/kb/156501/EN-US/ )

INF: QUOTED_IDENTIFIER v� b? d�y v?i d?u ngo?c k�p ��n

V�?t qua gi� tr? c� b?n

Khi Transact-SQL tuy�n b? c� b?n ��?c bi?t �?n, nh�ng b?n ph?i v�?t qua trong m?t ho?c nhi?u gi� tr? c? th?, s? d?ng m? s? �� l� t��ng t? nh� m?u sau:

      DECLARE @TSQL varchar(8000), @VAR char(2)
      SELECT  @VAR = 'CA'
      SELECT  @TSQL = 'SELECT * FROM OPENQUERY(MyLinkedServer,''SELECT * FROM pubs.dbo.authors WHERE state = ''''' + @VAR + ''''''')'
      EXEC (@TSQL)

V�?t qua to�n b? truy v?n

Khi b?n ph?i v�?t qua trong c�c truy v?n Transact SQL to�n b? ho?c t�n m�y ch? ��?c li�n k?t (ho?c c? hai), s? d?ng m? s? �� l� t��ng t? nh� m?u sau:

DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'MyLinkedServer'
SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''
SET @TSQL = 'SELECT au_lname, au_id FROM pubs..authors'')' 
EXEC (@OPENQUERY+@TSQL)

S? d?ng Sp_executesql l�u tr? th? t?c

�? tr�nh c�c d?u ngo?c k�p �a l?p, s? d?ng m? s? �� l� t��ng t? nh� m?u sau:

DECLARE @VAR char(2)
SELECT  @VAR = 'CA'
EXEC MyLinkedServer.master.dbo.sp_executesql
     N'SELECT * FROM pubs.dbo.authors WHERE state = @state',
     N'@state char(2)',
     @VAR

Quay l?i �?u trang | Cung c��p Pha�n h��i

THAM KH?O

�? bi?t th�m chi ti?t, xem c�c ch? �? sau trong SQL Server s�ch tr?c tuy?n:

"OPENROWSET"
"OPENQUERY"
"OPENDATASOURCE"
"B?ng c�ch s? d?ng sp_executesql"
"sp_executesql"

Quay l?i �?u trang | Cung c��p Pha�n h��i

Thu?c t�nh

ID c?a b�i: 314520 - L?n xem x�t sau c�ng: 27 Tha�ng Ta�m 2011 - Xem x�t l?i: 2.0

�p d?ng

Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 64-bit Edition
Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Workgroup Edition

kbhowtomaster kbmt KB314520 KbMtvi

M�y d?ch

QUAN TRO�NG: B�i vi?t n�y ��?c d?ch b?ng ph?n m?m d?ch m�y c?a Microsoft ch? kh�ng ph?i do con ng�?i d?ch. Microsoft cung c?p c�c b�i vi?t do con ng�?i d?ch v� c? c�c b�i vi?t do m�y d?ch �? b?n c� th? truy c?p v�o t?t c? c�c b�i vi?t trong C� s? Ki?n th?c c?a ch�ng t�i b?ng ng�n ng? c?a b?n. Tuy nhi�n, b�i vi?t do m�y d?ch kh�ng ph?i l�c n�o c?ng ho�n h?o. Lo?i b�i vi?t n�y c� th? ch?a c�c sai s�t v? t? v?ng, c� ph�p ho?c ng? ph�p, gi?ng nh� m?t ng�?i n�?c ngo�i c� th? m?c sai s�t khi n�i ng�n ng? c?a b?n. Microsoft kh�ng ch?u tr�ch nhi?m v? b?t k? s? thi?u ch�nh x�c, sai s�t ho?c thi?t h?i n�o do vi?c d?ch sai n?i dung ho?c do ho?t �?ng s? d?ng c?a kh�ch h�ng g�y ra. Microsoft c?ng th�?ng xuy�n c?p nh?t ph?n m?m d?ch m�y n�y.

Nh?p chu?t v�o ��y �? xem b?n ti?ng Anh c?a b�i vi?t n�y:314520

(http://support.microsoft.com/kb/314520/en-us/ )

Quay l?i �?u trang | Cung c��p Pha�n h��i