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>