Differences between functions and stored procedures?
- 8 Answers
- 13053 Views
- 247Customer, Accenture, I also Faced
- E-Mail Answers
Answer Posted / santhoshkumar.k
store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to insert data with null values?
How many types of triggers are there?
What command would you use to add a column to a table in sql server?
Is candidate a key?
What are the advantages to use stored procedures?
Explain throw statement in sql server 2008?
How do you rebuild an identity column?
How to create a view with data from multiple tables?
Which language rdl files made of?
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.
What are the disadvantages of merge replication?
Mention a few common trace flags used with sql server?
What is the partitioning method?
What are the restrictions that views have to follow? : SQL Server Architecture
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
