"Rogers" <Rogers@discussions.microsoft.com> wrote in message
news:8C6B4AB0-4A86-492F-8499-4AF52479C290@microsoft.com...
> Can any one let me know like I wanna save the text file into text column
> and > see the data through select statement.

"Rogers" <Rogers@discussions.microsoft.com> wrote in message
news:26AEAA01-79D9-4835-96EF-C0EFAB0A5867@microsoft.com...
>
> First of all thanks for your reply but now there is one question like
> let's
> assume we have saved the file in text column now I want to see the data so
> can I see like that
>
>
> select textfildname from tablename ?
>
> thanks
>
>
> "David Gugick" wrote:
>
>> "Rogers" <Rogers@discussions.microsoft.com> wrote in message
>> news:8C6B4AB0-4A86-492F-8499-4AF52479C290@microsoft.com...
>> > Can any one let me know like I wanna save the text file into text
>> > column
>> > and > see the data through select statement.
>>
>> You can create a stored procedure that uses a text or ntext parameter and
>> inserts into the table. If you can't easily paste the text into a tool
>> like
>> Query Analyzer to execute the procedure, you can use some client
>> application
>> code in .net or classic VB to open the text file, establish a connection
>> with the server, and execute the procedure.
>>
>> You may also be able to use the DTS Import wizard to process the file as
>> a
>> single row, single column file and insert into the table.
>>
>> --
>> David Gugick
>> Imceda Software
>> www.imceda.com
>>
>>
>>