SQL query : How to load picture from local directory to Sql server

[k_c]

I want to know Sql query to upload picture from my computer to Sql server 2008
For that i find that i have to use updatetext or write text
i dont know where should i put the location or path so it should copy
why using the following it stores the path not the image. i want to see the pic

declare @p binary (16)
SELECT @p =TEXTPTR (P_Photo) from P_DETAIL
where PERSON_ID = '1234'
updatetext P_DETAIL.P_Photo @p null 0 with log 'C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\pic.jpg'

[rmiao]

Try with writetext instead.