What is difference between stored procedure & function?
- 3 Answers
- 6108 Views
- CarrizalSoft Technologies, Concept Infoway, TATA, I also Faced
- E-Mail Answers
Answer Posted / shreenath27@yahoo.co.in
function will return value but procedure will not return any
value
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Tell me what is de-normalization and what are some of the examples of it?
define and explain the differences between clustered and non-clustered indexes.
What is the difference between indexing and hashing?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to rebuild indexes with alter index ... Rebuild?
Explain Normalization and DE normalization
What is shrink log file?
Can we delete data from a view?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are the reporting services components?
How to use values from other tables in update statements in ms sql server?
What happens if null values are involved in datetime operations?
What is triggers and stored procedures?
How you provide security to cube? : sql server analysis services, ssas
