Inserting without using INSERT INTO

16 Sep 2005 8:46 AM

DNKMCA

Hi,

How do i insert a value into varbinary column using ASP
Here i dont want to use "INSERT INTO"

Tx.
DNK

16 Sep 2005 8:53 AM

David Portas

Sorry, "INSERT INTO" is the answer if you want to insert. Maybe you
could you explain why you don't want to if that's not the answer you
are looking for.

Note however that you insert into *tables* not a column. Perhaps you
just mean you want to update a column in which case use UPDATE.

--
David Portas
SQL Server MVP
--

16 Sep 2005 9:10 AM

DNKMCA

I want to know is there a way i can put a value into VARBINARY Column thru
ASP Code.
-DNK

Show quote

"David Portas" <REMOVE_BEFORE_REPLYING_dpor***@acm.org> wrote in message
news:1126860791.506472.201910@f14g2000cwb.googlegroups.com...
> Sorry, "INSERT INTO" is the answer if you want to insert. Maybe you
> could you explain why you don't want to if that's not the answer you
> are looking for.
>
> Note however that you insert into *tables* not a column. Perhaps you
> just mean you want to update a column in which case use UPDATE.
>
> --
> David Portas
> SQL Server MVP
> --
>

16 Sep 2005 9:21 AM

David Portas

All updates should normally be done through stored procedures so the
answer is to call a proc using the ADO command object. The proc can
then perform the INSERT.

--
David Portas
SQL Server MVP
--

16 Sep 2005 10:32 AM

Erland Sommarskog

DNKMCA (d**@msn.com) writes:

> I want to know is there a way i can put a value into VARBINARY Column thru
> ASP Code.
> -DNK

If you want a sample about ASP, you may want to ask in an ASP forum.

From the SQL side of things, varbinary is not that much different than
any other data value.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp