Solved

Stored Procs Text datatype

Posted on 1998-11-19
2
185 Views
Last Modified: 2010-03-19
Can anyone tell me if it is possible to pass and return text data types to and from stored procedures?
0
Comment
Question by:carty
2 Comments
 
LVL 2

Accepted Solution

by:
formula earned 40 total points
ID: 1091879
I'm sure you cannot pass a text field to/from stored procedures, because there is no mechanism to write a text field (as "text") to a variable.  But you could convert to varchar(255) and pass that, however you would only get the first 255 characters of text.
0
 

Author Comment

by:carty
ID: 1091880
Thankyou for your answer,  I have accepted it because due to the time sensitive nature of my project I have opted for a quick solution.  If I had more time I would investigate deeper into RDO 2.0 and confirm for definite whether or not the object model supports returned text data.
Cheers again,


David
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Nested cursor  in SQL 9 94
System Center 2016 SQL Srv 1 24
What is format f12.8 for a CSV file 6 40
SSRS: My Data Source no longer has any dependent items ??? 2 12
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now