what is transaction table ,master table in SQL ?
Posted by Nav234
under Sql Server
on 7/9/2010 1:38:10 AM | Views : 14028 | Status : [Member]
| Replies : 1
I think you had already asked this question and @BangaruBabu had answered it in this post http://www.dotnetfunda.com/forums/thread2254-what-is-transaction-table-master-table-in-sql-server.aspx
View table (Its called View not View Table) is a virtual table that is used on top of other physical table in the database. In a single view you can write several joins to get data from several tables and you can get the data from view as if you are getting from table.
If your view name is MyView you can use following statement to get its data
SELECT * FROM MYVIEW where EmpId = 4
In the SQL Server Management studio, explore the database node and right click Views and select create new view and you will know how to create new view, its easy.
Hope this helps, thanksNav234, if this helps please login to Mark As Answer. | Alert Moderator