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

SS 2008: Front-End Language Processor for Scripts

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	2011-05-23 15:24 -0700
Organization	A noiseless patient Spider
Message-ID	<ctmlt61e9p7uarqa20uc24qurkdirv6lnv@4ax.com> (permalink)

Cross-posted to 2 groups.

Show all headers | 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