create database sqlOgreniyorum
create table Calisanlar(
CalisanID int not null,
Adi varchar(50) not null,
Soyadi varchar(50) not null,
Email varchar(50) not null,
TcNo nchar(11) not null,
Maas money not null,
DepartmanID int not null,
)
create table Departman(
DepartmanID int not null,
DepartmanAdi varchar(50) not null,
)
create function fncCalisanaGit(@CalisanID int)
returns table as
return (select * from Calisanlar where CalisanID = @CalisanID)
insert into Calisanlar values (1,'Ümit','Ünver','umit@gmail.com','12345678914',3500,1);
select * from dbo.fncCalisanaGit(1)
create function benimFonksiyonum(@Mesaj varchar(50))
returns varchar(50) as
begin
return (@Mesaj)
end
select dbo.benimFonksiyonum('Benim Fonksiyonum');
create function fncBirlestir(@Adi varchar(50), @Soyadi varchar(50))
returns varchar(50)
as
begin
declare @tamisim varchar(50)
set @tamisim = CONCAT(@Adi,'',@Soyadi)
return @tamisim
end
GO
create function birlestir(@v1 varchar(255), @v2 varchar(255))
returns varchar(255)
as
begin
return(select CONCAT(@v1 + ' ' ,@v2))
end
go
create function wherekullan(@id int)
returns varchar(255)
as
begin
return dbo.birlestir(
(select Adi from Calisanlar where CalisanID = @id),
(select Soyadi from Calisanlar where CalisanID = @id)
)
end
go
select dbo.wherekullan(1)