link server

Question

i want to get the server's date,but its not effect

select [linkserver].[database].[dbo].getDate()

 

Answer 1

Try following, maybe work:

SELECT * FROM OPENQUERY(linkserver, 'EXEC getdate()')

Answer 2

或者将getdate()封装在一个存储过程里

---

有dba的职位吗(北京的)，请联系我 stswordman#hotmail.com

Answer 3

ths all,its effect

Answer 4

你好，

正如楼上所说，你可以将GETDATE() 函数封装在一个存储过程里。请参阅下面的示例:

1. 在linked server 创建存储过程如下：

CREATE PROCEDURE p_GetDate
AS
SELECT GETDATE()

2. 执行该存储过程

EXEC [LinkedServerName].[TestDB].dbo.p_GetDate

谢谢,
邱爱华

---

Ai-hua Qiu[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.