What is function in SQL server ?

Question

Anonymous User · Answer

That is the SQL Functions are a database object in SQL Server. Mainly, it is a set of SQL statements that accept only input parameters, perform actions and return the result. A function can return only a single value or a table. You can’t use a function to Insert, Update, Delete records in the database tables.
Example:-and 
CREATE OR REPLACE FUNCTION totalCustomers 
RETURN number IS 
and  and total number(2) := 0; 
BEGIN 
and  and SELECT count(*) into total 
and  and FROM customers; 
and  and RETURN total; 
END;and

interview

What is function in SQL server ?

Anonymous User

Can you answer this question?

1 Answers

Liked By