[thelist] SQL Statement problem

[Howard Cheng]

At 05:21 PM 2/11/2002 -0600, Seth Bienek wrote:
>Frickin' SQL Server query builder keeps taking liberties with my queries..
>It's
>like trying to build a website using FrontPage. :)  I need to hunt down if
>there
>is a way to turn off the automatic reformatting it does every time you run a
>query..

Yeah, you'll want to use Query Analyzer to keep your queries in their
original form.

>One question.  When I create a view, is it stored on the SQL server?  More
>importantly, is it available across requests, or indefinitely, or only for the
>local request?  Do I access it as a "virtual table". just using the name given
>it in the create view statement?

I think once you create a view by statement, it's accessible in SQL
Enterprise Manager under the "Views" icon for your database, and it exists
until you drop it.


::::::::::::::::::::::
Howard Cheng
howcheng at ix.netcom.com
AIM: bennyphoebe
ICQ: 47319315