When should I use a function rather than a stored procedure in SQL, and vice versa? What is the purpose of each?

Sep 28, 2009 · I'm writing a user-defined function in SQL Server 2008. I know that functions cannot raise errors in the usual way - if you try to include the RAISERROR statement SQL returns: Msg 443, …

This is more of a syntax question I'm trying to write a store procedure or function that I can embed into a query such as: select * from MyBigProcOrFunction I'm trying to define a tabular function...

Jun 17, 2009 · How could you remove all characters that are not alphabetic from a string? What about non-alphanumeric? Does this have to be a custom function or are there also more generalizable …

Sep 6, 2017 · 4 Yes, SQL functions are easy to create. But you have to understand the 3 different types of functions in SQL: 1) Scalar functions: -- return a single value. 2) Table based functions: -- returns …

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of business days between the two dates. How can I call that function within my …

Mar 20, 2013 · 36 You can use sp_helptext command to view the definition. It simply does Displays the definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, user-defined …

Jun 26, 2009 · I understand that T-SQL is not object oriented. I need to write a set of functions that mimics method overloading in C#. Is function overloading supported in T-SQL in any way? If there is …

If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc... Is there a built-in function for this in SQL Server 2005/2008? Or do I need to use an auxiliary table?

I need to find out if a function exists in a database, so that I can drop it and create it again. It should basically be something like the following code that I use for stored procedures: IF EXIST...