Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How to use union to merge outputs from two queries together in ms sql server?
What is sql server profiler trace data file?
What is meant by indexing?
what is the difference between Delete and Truncate command in SQL
How to use "begin ... End" statement structures in ms sql server?
Can you name some of the dml commands in sql?
How to filter records of table in SQL SERVER?
How do I create a stored procedure in sql server?
What’s the use of custom fields in report?
What is sql stored procedure?
Explain the different index configurations a table can have?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How can you check the version of sql server?
What are ddl (data definition language) statements for tables in ms sql server?
