is there any way we can insert images into sql server directly instead of programmatically changing the image to a binary stream. plaese help asap.

In SQL Server BOL, look at the topic TextCopy. It might be what you are looking for.

thank, but i am not programming in mfc. the stantard way to insert an image is to declare an imaghe type then insert it using a binary stream well i intend to insert images using queries is that possible.