When to use View in Sql Server

Posted by Amatya under Sql Server on 4/17/2017 | Points: 10 | Views : 232 | Status : [Member] | Replies : 2
What is use of View in SQL Server. I want with example.

Thanks

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Sheonarayan on: 4/17/2017 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Amatya,

You can read this thread of DotNetFunda.com that has answer to your question - http://www.dotnetfunda.com/forums/show/18815/what-is-the-purpose-of-views-in-sql-server

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

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

Posted by: Amatya on: 4/20/2017 [Member] Silver | Points: 25

Up
0
Down
Yea.. thanks Sir I got it, Now I have 2 tables tblA and tblb, which doesnt have any relationship between them (No column values are column to them) Now I want to create a View in which two tables Columns are their. Is it possible ?
For Exp - tblA has 2 column Name, Address
TblB is having another two column say City, State

Now I want to create a View say ViewA which should have two column Say, Name and City

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

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

Login to post response