What is the difference between a view and a stored procedure?
- 1 Answers
- 1125 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sarvesh Kumar Prajapati
In SQL Server, a view is a virtual table based on the result-set of an SQL statement, whereas a stored procedure is a prepared SQL code that stores pre-compiled execution plans. A view does not modify data and cannot be executed like a standalone program; it simply represents the data in different formats for querying. On the other hand, a stored procedure can contain SQL statements to create, insert, update, delete or retrieve data and can accept parameters.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Disadvantages of the indexes?
How to convert numeric expression data types using the cast() function?
How to enter binary string literals in ms sql server?
Equi join and non equi join is possible with sql server?
What is an indexed view?
How to remove duplicate rows from table except one?
How to convert character strings into numeric values?
What is in place upgrade in sql server?
Explain system functions or built-in functions? What are different types of system functions?
How do I create a trace in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Where can you add custom error messages to sql server?
How to rebuild the master database?
How can we solve concurrency problems?
What is the difference between for xml raw and for xml auto?
