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
What stored by the model? : sql server database administration
What is snapshot report?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How do I schedule a sql server profiler trace?
Explain what are partitioned views and distributed partitioned views?
Explain syntax for dropping triggers?
What is truncate table?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Is null in sql server?
What is openxml in sql server?
What are tables in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Does group by or order by come first?
How to convert numeric expression data types using the cast() function?
What is sql server schema compare? How we can compare two database schemas?
