heres my first attempt at a real quine.
sql proc:
create proc q as declare @d varchar(500) set @d = 'create proc q as declare @d varchar(500) set @d = xyx select replace(replace(@d,char(120),char(39)),char(121),@d)' select replace(replace(@d,char(120),char(39)),char(121),@d)