| |
GeekInterview.com > Interview Questions > Database
| Print | |
Question: What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger?
|
| July 07, 2006 15:53:53 |
#2 |
| hmashruf |
Member Since: March 2006 Total Comments: 23 |
RE: What is the diff b/w a stored procedure and a view...
|
| Hi,Can we run select query by joining virtual table (view or logical table) and actual table (physical)? Or it just doesnt make sense to do, and the same can be accomplished by joining the actual table itself.Thanks,-ashruf |
| |
Back To Question | |
