Test your technical skills online, appear in Virtual Interview and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Forums Author
Wed, 23-Apr-2014 Authors
Saranpselvam
20
Sheonarayan
10
Sivakumar.S
10
All Time Authors
Jayakumars
3930
Karthikanbarasan
3455
Chvrsri
3140

Latest members | More ...


(Statistics delayed by 5 minutes)

what is transaction table ,master table in SQL ?

Nav234
Posted by Nav234 under Sql Server on 7/9/2010 1:38:10 AM | Views : 14028 | Status : [Member] | Replies : 1
Hi all

what is transaction table ,master table in SQL ?

what is view table and how to view VIEWTABLE records in sql ?

Thanks in advance

S.Naveen...

Reply | Reply with Attachment

=> Scroll below for responses


Comments or Responses

Posted by: Raja on: 7/9/2010 [Member] Starter

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.

for example

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, thanks

Regards,
Raja, USA

Nav234, if this helps please login to Mark As Answer. | Alert Moderator


Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.

Found interesting? Add this to: