datatype TEXT in stored procedure

Expand Post »

Hi

i want to use "text" datatype to declare a variable in stored procedure.
how can i do this???

Similar Threads

How to connect a SQL stored procedure to a windows application? in VB.NET

u4umang2001

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Nov 2007

Permalink

Feb 14th, 2008

Re: datatype TEXT in stored procedure

Click to Expand / Collapse Quote originally posted by u4umang2001 ...

Hi

i want to use "text" datatype to declare a variable in stored procedure.
how can i do this???

Hi u4umang2001,
Declaring a text variable in stored procedure is easy. Following example shows as below.

ASP.NET Syntax (Toggle Plain Text)
CREATE PROCEDURE sp_myStoredProcedure
   @myString varchar(100)
AS
.....
Go
CREATE PROCEDURE sp_myStoredProcedure
   @myString varchar(100)
AS
.....
Go

For detail understanding visit the link.
http://databases.about.com/od/sqlser...dprocedure.htm
Hope this will help you. For further assistance feel free to ask with me.
Thanks & Regards
Dilip Kumar Vishwakarma
Programmer
.Net Consulting

dilipv

Reputation Points: 10

Solved Threads: 4

Light Poster

Offline

30 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Using UserControls in ASP.NET

Next Thread in ASP.NET Forum Timeline: stored procedure problem

DaniWeb Message

Cancel Changes

User Name
Password