473,395 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

How to write stored procedure in plpgsql to connect to the sql server 2005?

6
Hi,

I just want to create a stored procedure/Function which should address the following features

1. Able to connect to the SQL Server 2005
2. fetch the data from tables
3. inserting into the postgresql database

Kindly suggest me the way forward or sample procedure
Feb 2 '11 #1
1 158077

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Mullin Yu | last post by:
i have a stored procedure at sql server 2k. which will update records and select result from temp table. if i use SqlConnection class, and i do both. but, if i use OleDbConnection class, i can...
0
by: stant | last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have...
4
by: eighthman11 | last post by:
I'm calling a stored procedure on a sql server from an access application. I just need the stored procedure to run I do not need any data returned from the stored procedure to my Access...
0
by: dwivedialok13 | last post by:
I am trying to debug a SQL server 2005 SP in VS 2005. I understand that there are two types of debugging (actully 3 but I am ignoring SQL/ CLR SPs written in C# etc). 1. Direct database...
2
by: Borf | last post by:
Hi, I'm new at this so I could use some advice. I need to call 1 or possible 2 DB2 z/os stored procedures from SQL Server 2005. What is the best way to accomplish this? This also needs to run at...
1
by: eighthman11 | last post by:
Hey everyone, Using Access 2003 and SQL Server 8.0 I have a stored procdure on SQL Server that is launched from my access database where I send the parms. The stored procedure on the server...
4
by: Garima12 | last post by:
There r some stored procedures in the database I m working with. When I create new stored procedure and save it, it does not appear in the list of existing procedures. Why so? Where should I store...
2
by: Erland Sommarskog | last post by:
Karl Rhodes (googlegroups@cortexa.co.uk) writes: The exact reason for the error is that you pass parameters to the command batch where you create the procedure. That does not fly. Nor would...
1
by: Sebrina | last post by:
I wrote a stored procedure which do a bulk insert into a table getting data from a text file. The data is inserted into a temp table and the I do an inserto to the original table. eg of figures ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.