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

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

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: How to Get Local Variables That Are Not So Local
Date	2012-05-30 20:50 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA063D3FF1B300Yazorman@127.0.0.1> (permalink)
References	<et1bs791hjssp3ppig64cnn1ufg2qgciu7@4ax.com> <XnsA0635EF73D48FYazorman@127.0.0.1> <p4kcs7pr11ldmtrgpmk5p5i6hsdnf6ofrk@4ax.com>

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      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.

Not really. The database consists of source code which should be under
version control. Handling of files is outside the scope of T-SQL.

>      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.

Script? Session-level possibly. A script is only something you have on
file, but SQL Server sees only one batch at a time.

>      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.

Why would it be a rougher ride to have your computer running two programs
running simultaneously. Multi-tasking is quite an old concept by now.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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