More about self-reproducing T-SQL

re: More about self-reproducing T-SQL

women — Thu, 14 Sep 2006 08:47:56 GMT

? good site, good short contents of the[url=http://plussizewomen.blogo.pl/]plus size women[/url]good work ?ongratulations !<a href=" http://plussizewomen.blogo.pl/ ">plus size women</a>

re: More about self-reproducing T-SQL

Ian Pennington — Sat, 05 Nov 2005 15:36:22 GMT

I think this should be:

exec sp_executesql N"print left(@,31)

not 32 as you get a coule of extra quotes.

Can anyone tell me why i'm getting a load of white space on the second to last line before the quote? Other than that it works OK.

re: More about self-reproducing T-SQL

Snark — Mon, 31 Oct 2005 18:10:28 GMT

another version:

select replace ( a.a, char ( 37 ) + char ( 115 ), char ( 39 ) + a.a + char ( 39 ) ) from ( select 'select replace ( a.a, char ( 37 ) + char ( 115 ), char ( 39 ) + a.a + char ( 39 ) ) from ( select %s as a ) as a' as a ) as a

re: More about self-reproducing T-SQL

Dean Harding — Thu, 27 Oct 2005 08:47:05 GMT

There's a bug in the first one. It should be:

exec sp_executesql N"print left(@,32)

for the last two line (i.e. 32 instead of 29) otherwise it misses out on the '=' after the first 'set @' statement.