ASP.NET

ASP.NET RSS

datatype TEXT in stored procedure

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2007

Posts: 28

Reputation: u4umang2001 is an unknown quantity at this point

Solved Threads: 0

u4umang2001 u4umang2001 is offline

Offline

Light Poster

datatype TEXT in stored procedure

Feb 13th, 2008

Hi

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

Thanks & Regards
Umang

•

Join Date: Feb 2008

Posts: 30

Reputation: dilipv is an unknown quantity at this point

Solved Threads: 4

dilipv

Offline

Light Poster

Re: datatype TEXT in stored procedure

Feb 14th, 2008

•

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.

 Help with Code Tags 
 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