Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Assignment in text data type in sql server 2000

Hi all,

can any one tell me how to assign null value to text data type?

any help will be truely appreciated.

> can any one tell me how to assign null value to text data type?

You should be able to set the value to NULL as you would a column of any
data type:

UPDATE dbo.MyTable
SET MyTextColumn = NULL

Hope this helps.

Dan Guzman
SQL Server MVP

"Archana" <trialproduct2@yahoo.com> wrote in message



thanks for your reply.

I don't want to update text column of table.

I have one stored procedure with has text data type as output
paramter.  I want to set null value for this.

If i can't set null value then what operations i can perform with text
data type which passed to stored procedure as output parameter.

thanks in advance.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc