Interested to Buy Any Domain ? << Click Here >> for more details...
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 is difference between order by and group by?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What stored procedure can you use to display the current processes?
Can sql servers link to other servers?
How is table type constraint applied to a table?
What are the types of processing and explain each? : sql server analysis services, ssas
What is unique key constraint?
How to create an index on a view?
What is the xml datatype?
What method is used by the Command classes to execute SQL statements that return single values?
What is the difference between an index and a unique index?
Can we add a cpu to sql server?
What do you understand by the data quality services in sql server?
Can you please explain the difference between primary keys and foreign keys?
Why de-normalization required?
