Difference between Function and Procedure-in general?
Answer Posted / rohan
function can be written in select statement but stored
procedure cannot be written in a select statement
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What happens when unicode strings concatenate with non-unicode strings?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Tell me what is use of except clause? How it differs from not in clause?
whats the maximum size of view state??
What is inline variable assignment?
Explain optimistic and pessimistic concurrency?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is provisioning, billing and metering, and connection routing concepts in the service layer?
List some case manipulation functions in sql?
Is a primary key unique?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
Explain about Normalization?
how would you troubleshoot blocking? : Sql server database administration
what is the system function to get current user's user id? : Sql server database administration
What is store procedure? How do they work? When do you use?