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
List the data types available in mssql?
How to create a user name in a database?
What are horizontal and vertical scaling?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
what stored procedure can you use to display the current processes? : Sql server administration
What are SSL and TSL protocols?
What is pessimistic concurrency?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What does this statement do @@rowcount?
explain how to create a new schema in a database? : Sql server database administration
What information is maintained within the msdb database?
What is in place upgrade in sql server?
How to declare a cursor with "declare ... Cursor" in ms sql server?
How many databases can we create in a single server?
What do I need to start working with sql studio? : sql server management studio
