SELECT Q.FileName, Q.Size, Q.DocAuthor, W.Citizens7hip FROM OpenQuery(MyLinkedServer, 'SELECT FileName, Size, DocAuthor FROM SCOPE('' "D:\" '') WHERE CONTAINS(''"SQL Server" NEAR() text'') AND FileName LIKE ''%.doc%'' ' ) > 0 AS Q, writers AS W WHERE Q.DocAuthor = W.writer_name
给个例子了,
create proc you_name
as select * from table
就可以吧,有问题再说了,
begin
Query1.Close;
T := TBlobField.Create(Self);
T.FieldName := 'Images';
T.Name := Query1.Name + T.FieldName;
T.Index := Query1.FieldCount;
T.DataSet := Query1;
Query1.FieldDefs.UpDate;
Query1.Open;end;
FROM OpenQuery(MyLinkedServer,
'SELECT FileName, Size, DocAuthor
FROM SCOPE('' "D:\" '')
WHERE CONTAINS(''"SQL Server"
NEAR() text'')
AND FileName LIKE ''%.doc%'' '
) > 0 AS Q,
writers AS W
WHERE Q.DocAuthor = W.writer_name