Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: How to Get Local Variables That Are Not So Local

Show all headers | View raw

On Wed, 30 May 2012 07:20:08 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> 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

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

Thread

How to Get Local Variables That Are Not So Local Gene Wirchenko <genew@ocis.net> - 2012-05-29 19:55 -0700
  Re: How to Get Local Variables That Are Not So Local Erland Sommarskog <esquel@sommarskog.se> - 2012-05-30 07:20 +0000
    Re: How to Get Local Variables That Are Not So Local Gene Wirchenko <genew@ocis.net> - 2012-05-30 09:56 -0700
      Re: How to Get Local Variables That Are Not So Local Erland Sommarskog <esquel@sommarskog.se> - 2012-05-30 20:50 +0200
        Re: How to Get Local Variables That Are Not So Local Gene Wirchenko <genew@ocis.net> - 2012-05-30 13:31 -0700
          Re: How to Get Local Variables That Are Not So Local Erland Sommarskog <esquel@sommarskog.se> - 2012-05-31 07:23 +0000
  Re: How to Get Local Variables That Are Not So Local rja.carnegie@gmail.com - 2012-06-14 04:20 -0700
    Re: How to Get Local Variables That Are Not So Local Erland Sommarskog <esquel@sommarskog.se> - 2012-06-14 21:43 +0200
      Re: How to Get Local Variables That Are Not So Local Gene Wirchenko <genew@ocis.net> - 2012-06-14 14:58 -0700

csiph-web