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
- 19494 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
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is database replication?
What stored by the model? : sql server database administration
Write a sql query to get zero records from a table having n number of records?
query processing
How to modify an existing user defined function?
What is named calculation? : sql server analysis services, ssas
What is update_statistics command?
How can delete duplicate records in cte in sql server?
What is the difference between index seek vs. Index scan?
optimization techinques
How to enter unicode character string literals in ms sql server?
What is GUID in sql server?
What is BLOCK statements in SQL?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
