Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 19523 Views
- I also Faced
- E-Mail Answers
Answer Posted / mukesh
All above answers are exactly correct.
In a different approach my answer is,
View is for Static approach. We cannot create a view with dynamic values.
SP is for Dynamic/Run-time values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to test a dml trigger in ms sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Explain what are various ways to enhance the ssrs report?
What are the differences between DDL, DML and DCL in SQL?
What is sql language?
What is wide table?
Explain what are the restrictions while creating batches in sql server?
What is cube dimension? : sql server analysis services, ssas
Explain what is scheduled job and how to create it?
Why is sql server log file full?
What is sql collation?
what are user defined datatypes? : Sql server database administration
Can we hide the definition of a stored procedure from a use?
Can you explain about buffer cash and log cache in sql server?
What is Service Broker in sql server 2012?
