I have a text type field in a table.
I wrote a tored procedure to insert and update the tables record.
In the stored Procedure I accept the incomming parmeter as 
	@ParameterName_xxx text = null

Now I am finding a suitable datat type (for text data type parameter)  to 
be specified when calling this stroed proc.

Am I missing somethign out here ???

Rizan

SP sample


CREATE PROC usp_AddSubmission
	@LoginID		numeric,
	@AccessLevel		smallint,
	@CurrentDate		datetime	= NULL,
	@ParentUserID		numeric 	= 0,
	@Body			text		= NULL,	 -- PROBLEM IS HERE
	@Description		varchar(300)	= NULL,
	@Title			varchar(100)	= NULL,
	@Images		varchar(100)	= NULL,
	@CotergoryID		smallint 		= 0,