How to Run a stored procedure on a linked server and fetch the data on SQL Server 2005#

This is carried out by using openquery, setup the linked server in server objects. Then call the server using a tabled-valued function#


CREATE FUNCTION p_get_closing_prices
(	
	-- Add the parameters for the function here
	@valueDate datetime
	
)
RETURNS TABLE 
AS
RETURN 
(

select * from openquery(SALD157, 'exec CreditPricer.dbo.p_get_closing_prices ''18 feb 2008''') 

	
)


Back to SQL Server

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-1) was last changed on 24-May-2017 15:30 by UnknownAuthor
G’day (anonymous guest) My Prefs
  • View Page Source
  • This clear IPSec security association,
    clear ipsec sa peer X.X.X.X
    

All Pages

Page views: 1834

Private Tomcat

Linux

MySQL

Email

SQL Server

ASP

JSP

C#

Web Mail

Windows Plesk

Linux Plesk

PHP

Gaming

ASP.NET

Persits ASPUpload

Wiki Help

Referring Pages:
...nobody

JSPWiki v2.8.1