Views in sql 2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Views in sql 2008

Author

Topic

smitha
Posting Yak Master

100 Posts

Posted - 2010-11-10 : 05:56:27

I am using vba as front end and I am logging the data to sql table periodically. I have written queries in views based on the requirment. I am writing code in vba to view the data.
Now my problem is I am not able to view the data even though the data is existing in table.
Does the data gets automatically update in the views from table.
Please reply.

Smitha

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-10 : 06:02:21

See here: http://stackoverflow.com/questions/1846595/is-a-sqlserver-view-always-up-to-date

Maybe you are trying to view data that isn't commited?

No, you're never too old to Yak'n'Roll if you're too young to die.

smitha
Posting Yak Master

100 Posts

Posted - 2010-11-10 : 07:06:02

now I am confused. My simple question is to update view automatically what I should do?

quote:
Originally posted by webfred

See here: http://stackoverflow.com/questions/1846595/is-a-sqlserver-view-always-up-to-date

Maybe you are trying to view data that isn't commited?

No, you're never too old to Yak'n'Roll if you're too young to die.

Smitha

jcelko
Esteemed SQL Purist

547 Posts

Posted - 2010-11-11 : 13:09:02

The view is a SELECT statement that is executed every time it is invoked. All the data should be current.

--CELKO--
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources