From: genew@ocis.net   
      
   On Wed, 30 May 2012 07:20:08 +0000 (UTC), Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
      
   [snip]   
      
   >>      T-SQL does seem to be missing some of the oddest things.  Is this   
   >> another case of that, or is it that I just do not know about nonlocal   
   >> variable declarations?   
   >   
   >T-SQL is a language to query and modify relational database. For this it is   
   >a very powerful language.   
   >   
   >However, T-SQL is not a general-purpose language, and if you try to use it   
   >for something it is not intended, you will have to accept the raw edges.   
      
        I am using it to set up a database.  I think that it is intended   
   for that.  It still is missing things that surprise me.   
      
        I did solve my problem by creating/dropping a temporary table to   
   create a kludgy but working flag.  Script-level variables would be   
   much easier.   
      
   >If you want a smoother ride, move the administrative tasks to the client-   
   >side language of your choice.   
      
        I want something that I can use in SSMS.  Anything else will be a   
   rougher ride by just the fact of having to use more than one tool.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)