Functions vs Stored Procedures

by

If you’re likely to want to combine the result of this piece of code with other tables, then obviously a table-valued function will allow you to compose the results in a single SELECT statement.

Generally, there’s a hierarchy (View < TV Function < Stored Proc). You can do more in each one, but the ability to compose the outputs, and for the optimizer to get really involved decreases as the functionality increases.

So use whichever one minimally allows you to express your desired result.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Difference between language sql and language plpgsql in PostgreSQL functions
  3. How to create multiple one to one’s
  4. T-SQL Cast versus Convert
  5. What is a stored procedure?
  6. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  7. SQL Call Stored Procedure for each Row without using a cursor
  8. Execute Stored Procedure from a Function
  9. What is the difference between function and procedure in PL/SQL?
  10. Splitting the string in sql server
  11. Need to list all triggers in SQL Server database with table name and table’s schema
  12. How can I do a BEFORE UPDATED trigger with sql server?
  13. How do I pass a list as a parameter in a stored procedure?
  14. Why execute stored procedures is faster than SQL query from a script?
  15. Deferrable Constraints in SQL Server
  16. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
  17. How to sum up time field in SQL Server
  18. Know relationships between all the tables of database in SQL Server
  19. Comma separated values in a database field
  20. Can SQL Server Express LocalDB be connected to remotely?
  21. Functions with variable number of input parameters
  22. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  23. Using SQL Server as a DB queue with multiple clients
  24. Suggestions for implementing audit tables in SQL Server?
  25. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  26. SQL Server search using like while ignoring blank spaces
  27. What does ON [PRIMARY] mean?
  28. How do I list all the columns in a table?
  29. Dynamic order direction
  30. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?

Leave a Comment