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
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
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment