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
- 19259 Views
- I also Faced
- E-Mail Answers
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 are SSL and TSL protocols?
How to retrieve error messages using odbc_errormsg()?
How to loop through result set objects using mssql_fetch_array()?
How to create a dml trigger using create trigger statements?
What is difference between global temporary tables and local temporary tables?
What is federation member?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
please differentiate between delete and truncate?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the difference between delete and truncate statements?
Where are sql server user names and passwords stored in sql server?
Do you know how to store and query spatial data?
How to make a remote connection in a database?
What is an expensive query?
What are sparse columns?
