XPost: microsoft.public.sqlserver.programming   
   From: bap@shrdlu.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)