Difference between Function and Procedure-in general?
Answer Posted / arif
function can not have update,delete or insert statement but
Stored procedure can have
| Is This Answer Correct ? | 15 Yes | 9 No |
Post New Answer View All Answers
Explain table valued parameters in sql server? Why tvp used?
What is replication with database mirroring? : sql server database administration
How would you choose between a clustered and a non-clustered index?
How to find tables without indexes?
How to get nth highest salary from employee table.
What is the significance of null value and why should we avoid permitting null values?
Tell me about pre-defined functions of sql?
What is a ddl statement?
What is the command dbcc checkdb used for?
Does a sql server 2005 select statement require a from?
How to fine-tune reports?
How to count rows with the count(*) function in ms sql server?
How do you delete duplicate records in sql server?
What is dbcc updateusage?
How to replace null values in expressions using isnull()?