Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / what is function in sql server ?
Ask Question
Anonymous User
Anonymous User

A_Philosopher

I am a content writter !

Message

1 Answers

Anonymous User
Anonymous User 14 Jun 2019
Report Abuse

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:- 

CREATE OR REPLACE FUNCTION totalCustomers 

RETURN number IS 

   total number(2) := 0; 

BEGIN 

   SELECT count(*) into total 

   FROM customers; 

    

   RETURN total; 

END; 
MindStick Training