/*because the output parameter of master..xp_sprintf can not exceed 255,this script can not display the correct result.but the technique behind the code really works*/declare @1 varchar(255), @2 varchar(255), @3 varcharselect @3 = char(0x27), @2 = 'declare @1 varchar(255), @2 varchar(255), @3 varcharselect @3 = char(0x27), @2 = %s%s%s exec master..xp_sprintf @1 output, @2, @3, @2, @3print @1'exec master..xp_sprintf @1 output, @2, @3, @2, @3print @1
