Hi Friends
I want to know about Inline Table-Value User-Defined Function used in SQL?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vikrant MorePosted Oct 8, 2012, 7:17 AM
http://msdn.microsoft.com/en-us/library/ms189294(v=sql.105).aspx
Kunal VaishyaPosted Oct 8, 2012, 7:12 AM
create function udf_ParseDate
(
@date as datetime
) returns @dateinfo table
(
id int identity(1,1),
[date] datetime,
[year] int,
[month] smallint,
[day] smallint
)
as
begin
insert into @dateinfo
select @date, YEAR(@date), MONTH(@date), DAY(@date)
return;
end