Inline function in SQL Server

Question

I want to know what is Inline function in SQL server. Thank you.

Jignesh Trivedi · Answer

hi Please refer http://msdn.microsoft.com/en-us/library/aa214762%28v=sql.80%29.aspx http://msdn.microsoft.com/en-us/library/aa175924%28v=sql.80%29.aspx

Akkiraju Ivaturi · Answer

Inline functions are subset of user defined functions introduced in sql server 2000 SP3. You can say inline functions are parameterized views. By nature Views do not accept parameters in the search conditions. For example consider the following view Create view myView as select employeeid from employees where company = 'Microsoft' If you would like to introduce a variable called company you cannot do it in the above view and for this purpose we can use inline user defined function. It is as below: create function fn_GetEmployeesOfCompany (@company nvarchar(500)) returns table as return (select employeeid from employees where company = @company) go you can call the above function as below: select * from fn_getemployeesofcompany(n'Google')