总务会计怎样记账:谁能在SQL7.0下运行这段代码能成功,大家试一下?谢谢!

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/08 12:59:23
DECLARE @values char(100)
DECLARE @url CHAR(255)
set @values='44445534534451233'
SET @url='http://192.168.1.88/test.asp?v=' + RTRIM(@values)
DECLARE @xml INT
DECLARE @Err INT
DECLARE @returnValue VARCHAR(255)
DECLARE @src VARCHAR(255)
DECLARE @desc VARCHAR(255)

EXEC @err = sp_OACreate 'Microsoft.XMLDOM', @xml OUT
if @err <> 0
goto lberr

EXEC @err = sp_OAMethod @xml,'Load',@returnValue OUT,@url
if @err <> 0
goto lberr
return

lberr:
exec sp_oageterrorinfo 0,@src out,@desc out
select cast(@err as varbinary(4)) as 错误号
,@src as 错误源,@desc as 错误描述
没有人用SQL7.0吗??

没用过!