Member Avatar for u4umang2001

Hi

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

  • 2 Contributors
  • 1 Reply
  • 97 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by dilipv
Member Avatar for dilipv

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.

CREATE PROCEDURE sp_myStoredProcedure
   @myString varchar(100)
AS
.....
Go

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.