WRITETEXT

[MCnKC]

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[Ray Miao]

Check sql books online.


------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[mcnck]

I did--it is criptic. Why are you being so hateful?


------------
Ray Miao at 5/15/2002 12:27:14 PM

Check sql books online.


------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[MAK]

He has been like that for a very long time . i have been trying to create a sample write text syntax for the past 2 days for u. I could'nt come up with an answer.

Good luck. I will let u know when i know the answer.

BOL has nothing in it.

-MAK


------------
mcnck at 5/15/2002 1:05:53 PM

I did--it is criptic. Why are you being so hateful?


------------
Ray Miao at 5/15/2002 12:27:14 PM

Check sql books online.


------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[Carl Spackler]

You will have to forgive Ray Miao, he has a long history on this site on posting replies to questions that say 'read the book'. Frustrating for those who are looking for some quick expertise. Anytime you see a response from Ray Miao, you can be assured it will not be helpful.

So, don't take it personally, people have differing skill sets.



------------
mcnck at 5/15/2002 1:05:53 PM

I did--it is criptic. Why are you being so hateful?


------------
Ray Miao at 5/15/2002 12:27:14 PM

Check sql books online.


------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[Bill]

Perhaps someone could still post an example of how to use WRITETEXT, but go to this link to find an example of how to use TEXTCOPY using a stored procedure.

http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm


------------
mcnck at 5/15/2002 1:05:53 PM

I did--it is criptic. Why are you being so hateful?


------------
Ray Miao at 5/15/2002 12:27:14 PM

Check sql books online.


------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[Kumar]

Plase check this,
http://www.swynk.com/discuss_sql7/getmessage.asp?rootid=88179&id=88179

Hope this helps,
Kumar



------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)

[MAk]

This is the script used by my sister.
here we go

First you create a table for eg: testimage

1. create table testimage(img_id int,image_column)

2. Then create a default
as shown below


create default def_value
as space(1)

3. bind the default to the column which holds the image

sp_bindefault 'def_value','testimage.[image_column]'


insert the value for img_id as 1,2 or whatever you want and the image_column will by default have a space on that.

4. TEXTCOPY /Sserver_name /Ulogin /Ppassword /Ddatabase_name /Ttable_name
/Ccolumn_namewhere you store image /I /Fpath with filename of image file /W"WHERE img_id = 1"

your file will be copied into the imgage_column

do the textcopy command for /O by copying from the table to a testfile and see,
you will have the image.


-FYI

The same applys for text column too.

If all the text and image fields must contain a value before the Textcopy program will work, your initial database will be huge.
Even if you initialize each column with one space,
it will assign one 2K page for each text column and one for each image column for each row. if you had 1,000 rows or a million rows?
Adding 1,000 rows to the above example and initializing the text and image fields to one space each would take an additional 4 MB of data space.
Adding a million rows would require 4 GB of space! Think about that.

-MAK

------------
Kumar at 5/15/2002 6:18:57 PM

Plase check this,
http://www.swynk.com/discuss_sql7/getmessage.asp?rootid=88179&id=88179

Hope this helps,
Kumar



------------
MCnKC at 5/15/2002 10:28:33 AM

Is there an example of using writetext, please?


How do I add a row with a column of type IMAGE?

IMAGE column will hold a PDF file.
INSERT INTO Table (Image_Col) VALUES (....?)