function

[Rafat Ali Khan]

How to make a function in sql server-2008?

[Simon_Whale]

Have a read of this MSDN: Create Function[^] there are some examples at the bottom of the page

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[vvashishta]

CREATE FUNCTION 'functionname' AS -- -- -- - Happy Coding - Vishal Vashishta

[kmoorevs]

Table-Valued functions are awesome, like a view with input parameters. Like this:

CREATE FUNCTION [dbo].[Function_Name] (@inputParameter int) RETURNS table AS Return ( WHERE = @inputParameter [])
Works in sql 2000+.
"Go forth into the source" - Neal Morse