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

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-31 07:23 +0000
Organization	Erland Sommarskog
Message-ID	<XnsA0645F8B786FFYazorman@127.0.0.1> (permalink)
References	<et1bs791hjssp3ppig64cnn1ufg2qgciu7@4ax.com> <XnsA0635EF73D48FYazorman@127.0.0.1> <p4kcs7pr11ldmtrgpmk5p5i6hsdnf6ofrk@4ax.com> <XnsA063D3FF1B300Yazorman@127.0.0.1> <4a0ds7dikohq660ad1qjghnfcqnsr85r57@4ax.com>

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      I am not using source control yet (and might not).  

You should, and all my advice is based from this fundamental point of 
software engineering.

>      Am I missing a nuance regarding script vs. session?  Script-level
> would be less than session-level and quite possibly unwanted.  

Someone could open the file in some other editor and paste it into an open 
query window.

>      I would prefer it if T-SQL had some more of those things that
> general purpose languages have.  I might be different in this regard,
> but I would like the functionality, even if it ends up being a bit
> slower.  Arrays would be nice.  I am not the only one who misses them.

General programming languages usually can read and write files. This is
something which a very unusual activity in a database engine.

Anyway, you may have your opinions. I'm giving you the advice how to achieve
the best result with least pain given the circumstances.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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