SQL Server/T-SQL/Insert Delete Update/Insert Image

Inserting Images

   <source lang="sql">

1> 2> drop table Players 3> GO 1> create table Players ( 2> Player_Id int IDENTITY (1, 1) NOT NULL , 3> Photograph image NULL 4> ) 5> GO 1> 2> -- Inserting Images 3> 4> INSERT INTO Players (Photograph)VALUES (0xFFFFFFFF) 5> GO (1 rows affected) 1> 2> DECLARE @Pointer_Value varbinary(16) 3> SELECT @Pointer_Value = TEXTPTR(Photograph) 4> FROM Players 5> WHERE Player_ID = 1 6> WRITETEXT Players.Photograph @Pointer_Value "C:\k.bmp" 7> GO 1> 2> select * from Players 3> GO Player_Id Photograph

---

         1 0x433A5C6B2E626D70

(1 rows affected) 1> 2> drop table Players 3> GO 1>

      </source>