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

Re: SS 2008: Front-End Language Processor for Scripts

From	Bernard Peek <bap@shrdlu.com>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SS 2008: Front-End Language Processor for Scripts
Date	2011-05-25 17:27 +0100
Message-ID	<944ov3FetmU1@mid.individual.net> (permalink)
References	<ctmlt61e9p7uarqa20uc24qurkdirv6lnv@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw

On 23/05/11 23:24, Gene Wirchenko wrote:
> 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 is a simple substitution. Have you considered using sed?



-- 
Bernard Peek
bap@shrdlu.com

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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