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
What is xdr?
what is a traditional network library for sql servers? : Sql server database administration
What is indexed view? How to create it?
How to get a list all databases on the sql server?
What is simple indexing method?
What methods do you follow to protect from sql injection attack?
What are the advantages of paper records?
Explain about analysis services?
What are the steps you must follow to hide sql server instances?
What are triggers in ms sql server?
Define constraints and give an example of their use?
Explain what are the database objects? : SQL Server Architecture
How to change the password of a login name in ms sql server?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is a non equi join?