What is the difference between views and stored procedures?
Can we have input parameters for views?
Answer Posted / indhu karur
View:
V can define a select-query that retrieves
specific information from one or more tables
Sp:
A stored procedure can do much more: it can run
multiple sql-commands, has control-of-flow statements and
accepts
parameters
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Is null vs coalesce?
How do I get to sql server configuration manager?
How to filter records of table in SQL SERVER?
Explain syntax for viewing trigger?
What is optimistic concurrency?
What is the return type of executeupdate ()?
How do I run a trace in sql server?
Write a sql query to delete duplicate records from a table called table1
Why is normalisation important?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is the sql case statement used for? Explain with an example?
What is openrowset sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is trigger in salesforce?
SQL Server Architecture ?