Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a stored procedure and a user
defined function in sql server?
- 2 Answers
- 7704 Views
- Millennium, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.
2. Select Clause we cann't use stored procdure. but
fucntion we can use.
3. XMl Clause contain we can use stored procdure. but
function we cann't use.
4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.
By
Kumar.T
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
New concepts of sql server 2005 use in your project.
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is the syntax to execute the sys.dm_db_missing_index_details?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to assign null values to variables or columns?
What is transact-sql ddl trigger?
What is ssl in sql server?
Explain nested join?
what are the different types of SSRS reports?
How to implement service broker?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to create hyperlink from returned sql query ?
How will you know when statistics on a table are obsolete?
