Answer Posted / vimal
VIEWS
View is a virtual table
If we want to access specific column from specific table we
can go for views
JOINS
Sometimes we have to select data from two or more tables to
make our result complete we have to perform join
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How does clustered and non clustered index work?
Explain the various types of concurrency problem?
What is the difference between commit and rollback?
What is the difference in accessing db between sql server vs sql azure?
Can I disable or restrict ssrs export formats (rendering formats)?
What is indexing a document?
What is similarity and difference between truncate and delete in sql?
Differentiate between ms sql server reporting services vs crystal reports?
Explain what are the different index configurations a table can have?
What is a print index?
How to bind a view to the schema of the underlying tables?
What is SQL Azure Firewall?
How many types of triggers are there?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What types of replication are supported in sql server?