Top "Sql-view" questions

A database view is a stored query.

How to make a view column NOT NULL

I'm trying to create a view where I want a column to be only true or false. However, it seems …

sql sql-server-2008 nullable sql-view
Why do SQL Server Views needs to be refreshed every once in a while

Why do I have to write 'refresh view' scripts, and execute them every time I add or edit some fields …

sql-server refresh sql-view
CREATE VIEW Using multiple tables

Hi trying to create a view in oracle. However I'm getting errors in my code which I can't work out …

sql oracle sql-view
Convert nvarchar to int in order to join SQL tables in a view

I want to create a view which will display the info from two tables joined by different type fields. The …

sql int inner-join nvarchar sql-view
How do MySQL views work?

When I create a view I am basically making a new table that will automatically be transacted upon when data …

sql mysql sql-view
Table-Valued Function(TVF) vs. View

What's the difference between table-valued functions and views? Is there something you can do with 1 that's hard or impossible to …

sql-server sql-view sql-function
SQL Server add computed column in VIEW with conditions

Here is my situation: In my table i two fields: - Price (decimal (15,4) - TaxId (int) TaxId value is not …

sql sql-server-2008 calculated-columns sql-view
Cannot update view?

My site was developed using Drupal 6 running on a Postgresql 8.3 server on Ubuntu 11.10. Also webmin version 1.590. Now I want to …

postgresql sql-update sql-view
SQL Updatable View with joined tables

I have a view that looks similar to this, SELECT dbo.Staff.StaffId, dbo.Staff.StaffName, dbo.StaffPreferences.filter_type …

sql-server view sql-update sql-view
ORA-04063: view has errors

I have 3 users (schemas) in my database. User A holds table X I created a view Y for user B …

sql oracle ddl sql-view