Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subhash chandra
views snapsot of multiple table into one one vertual table.
views can be update,insert,delete,its effect base tables
depend upon..
if you update/insert when- base table is multiples/sigle
respectively
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create an index on an existing table in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is CTE in SQL
What are different type of Collation Sensitivity?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to convert numeric expression data types by assignment operations?
Why use “pivot” in sql server?
What is an expression in ms sql server?
what happens on checkpoint? : Sql server database administration
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the steps you can take to avoid “deadlocks”?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to automatically create a log when an exception is being received into SQL Server?
What is the default schema of your login session in ms sql server?
