Differences between functions and stored procedures?
Answer Posted / purushotam bhardwaj
FUnction use when you want to return any value only
but SP is best for all
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate rows in sql server?
Explain what are various ways to enhance the ssrs report?
Why does sql studio use a single registered database repository? : sql server management studio
What are the dis_advantages of stored procedures, triggers, indexes?
State the difference between local and global temporary tables?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Can binary strings be used in arithmetical operations?
Do you know data definition language, data control language and data manipulation language?
What is ssrs?
Can we linked SharePoint to a SQL database?
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.
Give me a SQL Query to find out the second largest company?
Do you know the capabilities of cursors?
What does null mean?
What are the events recorded in a transaction log?