Creating a View from SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I know that the View is a virtual table of another table. In addition I can't to pass values from a temporary table to a View.

Suppose that I want to use a table from my data base, but I want to add a column in the View instead of the table itself, how I can do that?

The only way that I figured out is creating an additional table which contains all the columns, pass the original to this one (so I will get all the columns with values and the column that I want), and then to the View...

Posted 19-Sep-10 11:47am

jalmonte

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Lantei · Answer 1 · 2010-09-20T03:22:00

ok I havent tried something like that before USING a view, but what I usually do is to rather use either a temporary table #table_name, a global table ##table_name or a declared table @table_name and I can easily do what you wanted to do. But of course it largely has to do with the scope within which I want to work in, with views I would assume you would want to work in a larger scope..I'm personally going to check up on doing it in a view now!
:)

Creating a View from SQL Server

1 solution

Solution 1

Add your solution here

Preview 0

Creating a View from SQL Server

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us