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’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Why use “in” clause in sql server?
What is difference between rownum and rowid?
Give me a SQL Query to find out the second largest company?
What is the return type of executeupdate ()?
Tell me about pre-defined functions of sql?
What do you understand by recursive stored procedures?
Why we need to use secondry database file? though, we can do same work using primary database file also.
State the difference between local and global temporary tables?
How to update values in a table with update statements in ms sql server?
Can sql servers linked to other servers?
What is a coalesce function?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain different types of Normalization.
What is table constraint?