Wednesday, 3 April 2013

#33. Function in sql server

alter function tes()
returns
@datas table
(
  nik varchar(20),
  officialname varchar(100)
)
as
begin
    DECLARE @data TABLE
    (
        nik varchar(20),
        officialname varchar(100)
    )

    INSERT INTO @datas (nik, officialname)
    select nik, officialname from memployee
   
    return
   
end

0 comments:

Post a Comment