SQL scaler fn

Question

I want to write this logic in SQL scaler Fn bool FN( int X int Y) { int Result = X * 2; if (Y return true ; else return false ; } how?!!!!

Roei Bar · Answer

here you go : CREATE FUNCTION fnGet (@X integer @Y integer) RETURNS Int AS BEGIN int Result = @X * 2; if(@Y RETURN true else RETURN false END GO