Groups > comp.databases.ms-sqlserver > #364

SS 2008: Front-End Language Processor for Scripts

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	SS 2008: Front-End Language Processor for Scripts
Date	Mon, 23 May 2011 15:24:47 -0700
Organization	A noiseless patient Spider
Lines	28
Message-ID	<ctmlt61e9p7uarqa20uc24qurkdirv6lnv@4ax.com> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Info	mx04.eternal-september.org; posting-host="7Qrvczazr82YckO5XW8Vtw"; logging-data="17815"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18B7pyrCIoapwShUYu9dBB7k0BsefkYuTQ="
X-Newsreader	Forte Agent 4.2/32.1118
Cancel-Lock	sha1:xfjSxhcsU/Sr1mbSz87D2LYTktA=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:364

Cross-posted to 2 groups.

Show key headers only | View raw

Dear SQLers:

     I am trying to get around some of the limitations of T-SQL.

     I wish to run a preprocessor over script files much as the C
preprocessor does for C programs.  File inclusion and symbol
definition commands are about all I need.  Does anyone know of one
that will work well with SQL Server script files?

     I want to be able to define symbols like
          #define ERRSTL N'50001: String %s is too long.'
in a secondary file and have statements like
          raiserror(ERRSTL,16,1,N'ACUK)
expand to
          raiserror(N'50001: String %s is too long.',16,1,N'ACUK)
This would allow me to freely reorganise error codes without having to
hunt manually, and it would allow me to have consistency over multiple
scripts.

     I have done some searching and apparently one such is m4, but I
have been unable to download it.  (I only get a partial download and
do not know how to proceed.)

     Any ideas?

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-23 15:24 -0700
  Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-24 07:21 +0000
    Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-24 17:21 -0700
      Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-25 12:39 +0000
        Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-25 12:46 -0700
          Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-25 23:33 +0200
            Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-25 15:21 -0700
              Re: SS 2008: Front-End Language Processor for Scripts Erland Sommarskog <esquel@sommarskog.se> - 2011-05-26 23:44 +0200
                Re: SS 2008: Front-End Language Processor for Scripts Gene Wirchenko <genew@ocis.net> - 2011-05-26 15:24 -0700
  Re: SS 2008: Front-End Language Processor for Scripts Bernard Peek <bap@shrdlu.com> - 2011-05-25 17:27 +0100

csiph-web