Moving images between tables - SP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Moving images between tables - SP

Author

Topic

myksdsu
Starting Member

13 Posts

Posted - 2007-05-11 : 13:04:14

I have two tables: Test_Base and Test_Run
When a test is approved i have a stored procedure to move two columns from Test_Run to Test_Base

Column 1: WriteFileLoc (varchar)
Column 2: image (xml file in a byte[])

However, when i execute the following procedure it moves an empty image = 0x

Any ideas to why it moves the varchar but not the image (the image i want to move isn't empty)?

CREATE PROCEDURE dbo.au_InsertFileListXml ( @RunID varchar(50))
AS

DECLARE @BaseID varchar(50)
DECLARE @WriteFileLoc varchar(50)

SELECT @BaseID = Test_ID, @WriteFileLoc = Test_WriteFileLoc FROM Test_Run WHERE Test_Run_ID = @RunID

IF @WriteFileLoc = 'N'
UPDATE Test_Base SET Test_FR_FileList_N = r.Test_FR_FileList_N, Test_WriteFileLoc = @WriteFileLoc FROM Test_Base b,Test_Run r WHERE b.Test_ID = @BaseID;
ELSE IF @WriteFileLoc = 'Y'
UPDATE Test_Base SET Test_FR_FileList_Y = r.Test_FR_FileList_Y, Test_WriteFileLoc = @WriteFileLoc FROM Test_Base b,Test_Run r WHERE b.Test_ID = @BaseID;
GO

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-11 : 13:14:51

Duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83477

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources